[SOLVED] MySQL auto-increment

[SJames]

When using an "INSERT INTO" statement, what should I put as the value for an auto incrementing cell?

 

ex: "INSERT INTO content VALUES (' [auto-incrementing field] ', '$content')";

 

Would I just leave it empty?

[Jessica]

Do your queries like this:

INSERT INTO tablename(column1, column2, etc) VALUES(value1, value2, etc)

Then simply don't list the auto-increment field in either the columns list or values list.

[SJames]

That makes sense, thank you.

[Jessica]

Sure thing. Also, you can use it to leave fields NULL or other default values by leaving them out. It's handy to do it this way, because if you need to add another column, you can ensure it has a default value and you won't have to edit ALL of your code, at least not immediately.