insert: auto increment field

[Mike Mapsnac]

I have table with 7 fields. First field is id (auto increment). As I 
understand the value should start from 0 and  next value will auto 
increment.

And I shouldn't add insert the value. So the insert
statemens below gives me an error. ERROR 1136:Column count doesn't match 
value count at row 1

insert into product values('456789','t1', 'new', 2, 2, 10);

_________________________________________________________________
Have fun customizing MSN Messenger — learn how here!  
http://www.msnmessenger-download.com/tracking/reach_customize

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]