Stooney Posted December 18, 2007 Share Posted December 18, 2007 Trying to insert about 3,000 rows of data in a table but ran into a prob I can't figure out. Here is the first of the queries. The error happens here also. (personal data removed, no punctuation was removed from query, only text) INSERT INTO stauctioneer_users( biddernum, lname, fname, address, city, state, zip, hphone ) VALUES ( '1026,LNAME,FNAME,ADDRESS,BEAUMONT,TEXAS,77705,***-***-**** ' ) Error: #1136 - Column count doesn't match value count at row 1 The table is set properly. I copied the table structure (via phpmyadmin) from one database to the other. I'm using the same data.txt and script to generate the insert queries as before with the old database, but it just won't work on this table. Link to comment https://forums.phpfreaks.com/topic/82159-solved-stuck-with-mysql-error/ Share on other sites More sharing options...
Stooney Posted December 18, 2007 Author Share Posted December 18, 2007 Unless the fact that the data is missing the single quotes....(i'm bad) Link to comment https://forums.phpfreaks.com/topic/82159-solved-stuck-with-mysql-error/#findComment-417490 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.