Normally it's a good habit to explicitly name the columns.
But it also works whithout naming them in the INSERT instruction when you
are inserting exactly in all the columns.
Thanks
Emery
----- Original Message -----
From: "Gregory Norman" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 12:44
Subject: Re: error message
> Thanks for your reply. I used the example from Rob and it worked. Does
this mean I will have to name all of the columns in a table with each
command?
>
> Gregory
>
> On Friday, October 17, 2003, at 05:13AM, Director General: NEFACOMP
<[EMAIL PROTECTED]> wrote:
>
> >That error means that the number of columns in the table is differnt from
> >the number of columns you are sending for insert.
> >For my system (4.1.0) I have got 14 fields.
> >For your query, you are trying to insert 12 fields.
> >Normally this should work even if the the number of fields is different
and
> >the rest should be changed into their defaults.
> >
> >
> >Just try to check what are the indexes, ....
> >
> >
> >Thanks
> >Emery
> >----- Original Message -----
> >From: "Gregory Norman" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Friday, October 17, 2003 10:31
> >Subject: error message
> >
> >
> >> Hello,
> >>
> >> I am new to mysql trying to learn by following the instructions from a
> >trainning book. While following the instructions from the book that I am
> >using I got the following error message, without the quotes, "Column
count
> >doesn't match value count at row 1". I entered the following command,
> >>
> >> INSERT INTO host
>
>VALUES('localhost','database_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
;
> >>
> >> According to the book that I am using this command should add the
> >hostname/database combination to the MySQL RDBMS.
> >>
> >> I have searched for this error message unsuccessfully at MySQL's
website.
> >If someone would explain to me what I am doing wrong, or where I can find
> >information that will help me get past this point I would appreciate it.
BTW
> >I am using version 40.0.14.
> >>
> >> Gregory Norman
> >>
> >> --
> >> 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]
> >
> >
> >
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
