mysql doubt

ashay

I have a table with 124 fields in it...but I am writing a query that INSERTS only 62 fields of it.
But Mysql is not allowing me to do so.?

I though that if I explicitely mention all the 62 fields to be inserted, mysql will allow me to insert the field values.

but it throws the following error

MySQL said:

Column count doesn't match value count at row 1

....
is it that I have to insert all 124 fields (with remining 124-62 fields as null, or i should be allowed to insert 64 columns only...)

PS: apart from my primary key, all the the other filds are initialized to NULL.

ashay

stolzyboy

are you doing

insert into table values (values)

insert into table (fieldname) values (values)

cuz if you use the first one, you must specify values for ALL columns regardless if you just use '' (nothing), but you need to have something accounting for that spot

give this a read for more info

http://www.mysql.com/doc/en/INSERT.html

kevinsequeira

what the erro means is the number of columns u have specified in the sql is not equal to the number of data columns.

insert into tablename (name,address,country) values('me','montreal');

since u have 62 fields i think uve missed some values..

echo the sql and debug

reg
kevin

paulnaj

You're right ... you can do what you want using VALUES('value', 'value', ...) syntax in the INSERT query.

It sounds like a typo ... maybe an extra/missing comma ... in the INSERT query, especially as you're inserting 62 values at a time.

ashay

Well I have cross checked everythiong and columns match with each data fields..

and I am doing

insert into table (colname,colname, colname,...62 times) values (colval,colval,..62 times).

ahundiak

Post your insert statement. There was another thread with a similiar problem and they were just missing a couple of commas.

Better yet, copy your insert statement then chop it down to 5 fields. Get that to work then paste in another 10 or fields. Keep repeating until the problem reveals itself.

ashay

INSERT INTO master_bookstore( DATE1, DUEDATE, JOBNUMBER, TERM, YEAR, COPYRIGHT, RANK, INSTRUCTOR, FIRSTNAME, PNUMONE, EMAIL1, CONTACT, CONTACTFIRSTNAME, PNUMTWO, EMAIL2, DEPARTMENT, COURSENUMBER, SECTION, SKU, COURSETITLE, ESTIMATEDENROLLMENT, INSTRUCTORCOPIES, INITIALRUN, DISCOUNT, TOTALREPRINTSORDERED, INVENTORY, STORE, VENDOR, IMPRESSIONS, PRINTING, SIDE, PRINTCOST, COVER, COVERCOST, BINDING, BINDINGCOST, INSERTS, INSERTCOST, COLLATION, COLLATIONCOST, TABS, TABSCOST, BINDER, BINDERCOST, OTHERCHARGES, STATUS1, STATUSDATE, PRODUCTION, PERMISSION, ANCILLARY, RETAIL, PRODUCTIONPERIMP, INITRUNPERCOFESTENROLL, TOTALSOLD, SELLTHROUGHPERC, SELLTHROUGHPERCEST, ORIGINALMASTER, PULLMASTER, ELECTRONICRESERVE, PERMISSIONPERIMP, NOTES )
VALUES (
" '2003-03-03','2003-05-05','01877878','Summer','211','2000','Prof','Williamson','Henry','x8999','wil@usc.edu','Rad','Gary','x2267','gary@usc.edu','MGMT','234','2','777','Programming for Management Students','56','2','45','20','1','2','USC CAMPUS','Universal','222','0.8','0.098','5.6','6','0.8','KOIL:SMALL','2.5','0','0','0','0','0','0','NON','0','0','SHIPPED','2003-06-12','55','22','12','89','0.04','12','25','23','23','1','2','1','0.04','This data was added by ashay on 06/12/2003'"
)

ashay

Thanks a lot for all ure help