Inserting values into a table.

[richardstan]

Hi, i have a mysql table with the following columns

id, title, description, name, location.

 

when i'm using the insert statement, do i need to put a value in for the ID field if i have set it to INT NOT NULL AUTO_INCREMENT?

for example, is the right code?

INSERT INTO LISTINGS(ID, TITLE, DESCRIPTION, NAME, LOCATION) VALUES (1, JUG, 2000 YEARS OLD, RICHARD, KENT)

 

or

 

INSERT INTO LISTINGS(TITLE, DESCRIPTION, NAME, LOCATION) VALUES (JUG, 2000 YEARS OLD, RICHARD, KENT)

 

 

thanks

richard.

 

[corbin]

No you do not put a value.  Infact, it will probably error if you provide a value.  It's called "auto" incrementing for a reason ;p.

[fenway]

In theory, you can put 0 or NULL, but you shouldn't do either.