Skip navigation links

MySQL Forums :: PHP :: Column count doesn't match value count at row 1???????


Advanced Search

Column count doesn't match value count at row 1???????
Posted by: Steve Penn ()
Date: December 27, 2007 08:13PM

I am using the following query and getting the following error.

A copy of my query.
insert into p90x.employee ( empid, empFname. empLname, empMname, empssn, empAddressid, empCompanyid ) values ( NULL, 'Steve', 'Penn', 'jason', 89898787, NULL, '6' )

ERROR
Could Not insert Record into Employee Table
Column count doesn't match value count at row 1


Have you seen this before?

Below is the table in question.

Field Type Collation Null
empid int(9)
empFname varchar(80)
empLname varchar(80)
empMname varchar(50)
empssn int(15)
empAddressId int(9)
empCompanyid int(9)

I have other tables in this database that allow me to input one column if I so desire.

I have read some forums that suggest that I should list the columns I am inserting into, however this is not necessary in my other tables of this database.

Any useful assistance would be greatly appreciated.

Sandfly BIP!

Options: ReplyQuote


Subject Written By Posted
Column count doesn't match value count at row 1??????? Steve Penn 12/27/2007 08:13PM
Re: Column count doesn't match value count at row 1??????? Peter Brawley 12/27/2007 11:06PM
Re: Column count doesn't match value count at row 1??????? John Smith 05/24/2008 08:20PM
Re: Column count doesn't match value count at row 1??????? Steve Penn 12/28/2007 09:51AM
Re: Column count doesn't match value count at row 1??????? Peter Brawley 12/28/2007 01:24PM
Re: Column count doesn't match value count at row 1??????? Leo Aulenta 06/23/2008 03:20AM
Re: Column count doesn't match value count at row 1??????? Peter Brawley 06/23/2008 09:09AM
Re: Column count doesn't match value count at row 1??????? Leo Aulenta 06/24/2008 03:33AM
Re: Column count doesn't match value count at row 1??????? Leo Aulenta 06/24/2008 03:50AM
Re: Column count doesn't match value count at row 1??????? Peter Brawley 06/24/2008 08:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.