Link to home
Start Free TrialLog in
Avatar of johnhardy
johnhardyFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of TvMpt
TvMpt
Flag of Portugal image

Hi.

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?
Avatar of johnhardy

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
SOLUTION
Avatar of Ahmed Hussein
Ahmed Hussein
Flag of Egypt image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Many thanks