Amending tables

[expired user #9997]'s profile image [expired user #9997] posted 8 years ago in General Permalink

I'm a new user to Heidi and I have an existing set of tables which all work fine from my website. However, i've just created a new table copying from an existing but when I try to add records from my website I get an error "Cannot insert the value NULL into column 'id'". I can write to the original file without problem. I tried to edit the new table to auto-increment the id column but I get an error 102 Incorrect syntax near 'AUTO_INCREMENT' and if I try to edit any column I get a similar error 156 Incorrect syntax near the keyword 'DEFAULT'. Can anyone point out what's going on?

[expired user #10404]'s profile image [expired user #10404] posted 7 years ago Permalink

Even I am facing the same problem .. can someone help

Please login to leave a reply, or register at first.