hi
the error is because you have more or fewer items of data than fields or
columns to put it in
it is better practice to include fields in your query
INSERT INTO sometable
(
field1
, field2
, field3
)
VALUES
(
"data"
, "more data"
, "even more"
);
Peter
> -----Original Message-----
> From: Leon Ellis [mailto:[EMAIL PROTECTED]
> Sent: 26 June 2004 10:14
> To: MYSQL
> Subject: MYSQL Setup Question
>
>
> I am brand new to MySQL
> Running MYSQL 4.0.16 on FreeBSD.
> When I try to add a user, with the following code I
> get an error.
> INSERT INTO user
> VALUES
> ('localhost','username',password('Secret'),
> 'Y','Y',...);
> I have used inwhere from 6 'Y's (Friends
> Recommendation) to 14 'y's MYSQL manual.
> I get the following error:
> Column count doesn't match value count at row 1.
> What did I do wrong.
> Thanx in advance.
> Leon
>
>
>
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - Send 10MB messages!
> http://promotions.yahoo.com/new_mail
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
