MySQL Forums
Forum List  »  PHP

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' )

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

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.