INSERT a row when an auto_increment field exists

[mellenburg]

I'm trying to insert a row into a table where I have an id field that is an auto_increment and primary key.

When trying to do an insert, what do I put for the id field in the values statement?

If I put nothing, the record does not get inserted.

 

[sleipnir214]

It depends. Do you want MySQL to provide the value for id, or do you want to do it?

If the former, don't reference the field id at all:
INSERT INTO tablename (column2, column3) values ('a','b')

MySQL will generate a value for id automatically.

If the latter, just reference the column and pass in a value. Keep in mind that primary key columns must be unique -- duplicate a key and the insert will barf:

INSERT INTO tablename (id, column2, column3) values (4, 'a', 'b')

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!