On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote:
> 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);
Try using NULL for the id field, thusly:
insert into product values (NULL,'456789','t1','new',2,2,10);
I didn't actually try this but it should work.
Don Henson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
