PHP MYSQL - Insert into without using column names but with autoincrement field
I need to insert a long row with 32 fields into a MySQL table.
I'd like to do something like this:
$sql="insert into tblname values (... 32 fields ...)";
Obviously it works fine if the fields are in the same order as the MySQL table fields. But, my table has an auto-increment id as it's first field.
What I want is to fill in all table names but the first (id) one.
Suggestions?
Solution 1:
Just use NULL
as your first value, the autoincrement
field will still work as expected:
INSERT INTO tblname VALUES (NULL, ... 32 Fields ... )
Solution 2:
Insert NULL
into the auto-increment field.
I recommend that unless this is a hack script, you use field names. The rationale is that your code will break if you ever add a field to the table or change their order.
Instead, be explicit with field names, and it will go much better in the future.