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: mysql> insert into SalesSupData(ClientId, SupTypeId, Description, UserId) values (2,2,'test',140); --Rob ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
