So I have an auto increment column (As my first column), but I don't know how to write the insert command because of it.
I tried like that:
objConn.Execute("INSERT INTO TABLE VALUES ('','SecondElement')")
But it didn't work
I tried to write the right number, meanning
objConn.Execute("INSERT INTO TABLE VALUES ('1','SecondElement')")
and it work, but I want a general command, because I don't want a check each time, what should be the next number, anyone knows how to do it?
you don't pass anything for the auto number field, mysql takes care of that. your insert sql statement must be in that format to work correctly. just don't put anything in there for the auto number field liked russell mentioned