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!