update doesn't

[william drescher]

I have a table ("tasks") with:
task_id  mediumint(9)
status   char(1)
priority char(1)
and more fields
when I do the following (using phpMyAdmin):
update tasks
set status='H'
where task_id='1'

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?

I discovered this because the application was failing to change 
the W to a H using update syntax.

bill






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql