Inserting values with any column being auto increment

by Sanju 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.

Tagged in:

972
like
0
dislike
0
mail
flag

You must LOGIN to add comments