I have done something to my MySQL database
I can do other queries fine - updade, select, delete all work fine - just not INSERT
The user has the privilege to do update. "ALL PRIVILEGES" is set..
I am using code that I know is right because I haven't changed it and it worked fine a few days ago. I have tried writing new code specifically to get any sort of update working...
Code: Select all
CREATE TABLE `test` (
`id` INT( 10 ) NOT NULL ,
`name` VARCHAR( 20 ) NOT NULL
)Code: Select all
INSERT INTO `test` ( `id` , `name` )
VALUES (
'2', 'tt'
);Is there some kind of privilege I may be missing? Well, there must be, but I have no idea what... Help! Thanks in advance!