MySql INSERT statement requires field names

[cupboy]

If I use SQL Server with a table that has an identity column I can still do an insert without specifying column names.

In MySql with a table that has an autoincrement column I have to specify all the column names when doing an INSERT. Is there a way around that?

[AIS4U]

cupboy:

I'm not sure if this is what you are talking about or not?

The usual form for a MySQL INSERT statement is:
INSERT [INTO] table [(column1, column2, column2, ...)]
VALUES (value1, value2, value3, ...);

So, if you had a database with a table called Customers and 4 fields:
field1 autoincrement
field2 name
field3 address
field4 city
you could insert into that table by writing code:
Insert into customers values
(NULL, "Julie Smith", "345 W. 5th Street", "SomeCity");
The values specified will be used to fill in the columns in order.
If you want to fill in only some of the columns or specify them in a different order, you can list the specific column in the columns part of the statement. For example:
Insert into Customers (name, city)
Values ("Molly Adams", "OtherCity");

or you can use SET:

Insert into Customers
set name="John Doe",
address="234 That Street",
city="YourCity";

I'm not sure if this is what you were asking or not?

Good Luck