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. Quote Link to comment 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) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.