Inserting values with any column being auto increment - Mysql Views : 255
Tagged in : Mysql
0 0
Send mail
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.
By Sanju, On - 2010-01-27



    Login to add Comments .