johnhardy
asked on
MySql will not update via phpmyadmin
Hello,
I have a MySql database on a 1and1 server.
I wish to update a field tinyint(1) which defaults to NULL.
I use phpmyadmin
From Browse I go into the edit form and update the field with a tick box.
When I look at the record via Browse the field is still at NULL.
If I go back into Edit Mode the tick box is still ticked.
Has anyone any idea how this can be rectified please?
Many thanks
John
I have a MySql database on a 1and1 server.
I wish to update a field tinyint(1) which defaults to NULL.
I use phpmyadmin
From Browse I go into the edit form and update the field with a tick box.
When I look at the record via Browse the field is still at NULL.
If I go back into Edit Mode the tick box is still ticked.
Has anyone any idea how this can be rectified please?
Many thanks
John
ASKER
I am not sure if the edit form is a normal part of phpmyadmin I expect it is.
I am attaching a shot of the edit / update form
Edit-Form.jpg
I am attaching a shot of the edit / update form
Edit-Form.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Many thanks
I guess when you change the table structure and the field still accepts null you must update all records with a number from [0..9] (tinyint(1))
Could you show a screenshot of the tick box you are talking?