If you are going to specify values for all columns in your insert, you should
put NULL as the value for an AUTO_INCREMENT column, e.g.
mysql insert into SalesSupData values (NULL,2,2,'test',140);
My preferred way however is to put the column names and just miss out the
auto_increment column:
On 6/13/06, Rob Desbois [EMAIL PROTECTED] wrote:
If you are going to specify values for all columns in your insert, you should
put NULL as the value for an AUTO_INCREMENT column, e.g.
mysql insert into SalesSupData values (NULL,2,2,'test',140);
My preferred way however is to put the column