Inserting values with any column being auto increment
by Sanju[ Edit ] 2010-01-27 20:14:54
Inserting values with any column being auto increment
Insert values with id or any column being auto increment will not work if you use single quotes ''.
Won't Work
insert into xx values('NULL', 'Sanju', 55)
Following will works
insert into xx values(NULL, 'Sanju', 55)
Instead you have use null in mysql 5.