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 names and just miss out the
auto_increment column:
mysql> insert into SalesSupData(ClientId, SupTypeId, Description, UserId)
values (2,2,'test',140);
--Rob
That works....
thanks
Digz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
