Re: Incorrect records getting updated with Mysql 3.23.56
Maybe you can make a test,
LOCK TABLE rfanew WRITE;
SELECT count(*) FROM rfanew WHERE fin_Status='A';
UPDATE rfanew set fin_Status='A',alt_rfa_no='',ret_dt='' WHERE rfa_id=20061;
SELECT count(*) FROM rfanew WHERE fin_Status='A';
UNLOCK TABLES;
If result is wrong, then you may want to CHECK the tables, and REPAIR it if there is any problem.
If result is still wrong, then you may want to report a bug, but you should upgrade first to the latest 3.23 release. And MySQL is stopping the support of 3.23 and 4.0, you may want to plan for upgrade to newer versions.
Subject
Views
Written By
Posted
2186
July 24, 2006 04:04AM
1348
July 24, 2006 10:29PM
1430
July 25, 2006 12:47AM
Re: Incorrect records getting updated with Mysql 3.23.56
1522
July 25, 2006 07:17PM
1532
July 25, 2006 08:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.