The client indicates a warning after the update. Issue a show warnings after the update. On Aug 19, 2012 11:19 AM, "william drescher" <will...@techservsys.com> wrote:
> On 8/17/2012 12:13 PM, Rik Wasmus wrote: > >> I get 1 row affected, but the status does not change when I look >>> at the row. >>> >>> If I set it to 'X' it does change. >>> >>> To make it even more wacky, if I (using phpMyAdmin) change it to >>> 'H' it will change and the row is shown change, but when I go to >>> examine the row (using the pencil icon=Edit) it changes back to 'W'. >>> >>> Either there is something really strange or my mysql is possessed. >>> >>> I am using Server version: 5.1.63-0ubuntu0.10.04. >>> >>> Anyone have any thoughts about this or suggestions on how to >>> debug it? >>> >> >> 1) One thing that _could_ do this is a trigger. Does SHOW TRIGGERS; show >> any >> that could be doing this? >> >> 2) However, in 99.999% of cases, it is just a logic error in the >> application >> (be it your application or PHPMyAdmin), not anything in MySQL. Can you >> connect >> with the command line client, run the UPDATE statement, en then check >> what the >> SELECT shows? If it shows a correct result... the problem ain't in MySQL >> itself. >> >> mysql> select status from tasks; > +--------+ > | status | > +--------+ > | W | > +--------+ > 1 row in set (0.00 sec) > > mysql> update tasks set status= 'H'; > Query OK, 1 row affected (0.00 sec) > Rows matched: 1 Changed 1 Warnings: 0 > > mysql> select status from tasks; > +--------+ > | status | > +--------+ > | W | > +--------+ > 1 row in set (0.00 sec) > > whoops > > bill > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >