DrTrans Posted June 19, 2012 Share Posted June 19, 2012 Im getting this error multiple times Have 2 Tables 1 named Applicant 1 named Application Went into Operations and went to copy the table into Application and get this error: MySQL said: #1136 - Column count doesn't match value count at row 1 Quote Link to comment Share on other sites More sharing options...
Jessica Posted June 19, 2012 Share Posted June 19, 2012 And what do the tables look like? Quote Link to comment Share on other sites More sharing options...
DrTrans Posted June 19, 2012 Author Share Posted June 19, 2012 Applicant has less fields then application Ex. Applicant Structure is: # Column Type Collation Attributes Null Default Extra Action 1 appID int(11) No None AUTO_INCREMENT Change Drop More 2 loginid int(10) No None Change Drop More 3 fname varchar(50) latin1_swedish_ci Yes NULL Change Drop More 4 lname varchar(50) latin1_swedish_ci Yes NULL Change Drop More 5 workphone varchar(50) latin1_swedish_ci Yes NULL Change Drop More 6 homephone varchar(50) latin1_swedish_ci Yes NULL Change Drop More 7 dob datetime Yes NULL Change Drop More 8 dlnumber varchar(50) latin1_swedish_ci Yes NULL Change Drop More 9 dlstate varchar(2) latin1_swedish_ci Yes NULL and Application is 1 appID int(11) No None AUTO_INCREMENT Change Drop More 2 loginid int(11) Yes NULL Change Drop More 3 fname varchar(50) latin1_swedish_ci Yes Change Drop More 4 lname varchar(50) latin1_swedish_ci Yes Change Drop More 5 addy varchar(100) latin1_swedish_ci Yes Change Drop More 6 city varchar(100) latin1_swedish_ci Yes Change Drop More 7 state varchar(100) latin1_swedish_ci Yes Change Drop More 8 zip varchar(100) latin1_swedish_ci Yes Change Drop More 9 homephone varchar(100) latin1_swedish_ci Yes Change Drop More 10 workphone varchar(100) latin1_swedish_ci Yes Change Drop More 11 social varchar(100) latin1_swedish_ci Yes Change Drop More 12 dob varchar(100) latin1_swedish_ci Yes Change Drop More 13 appEmail varchar(100) latin1_swedish_ci Yes Change Drop More 14 dlnumber varchar(100) latin1_swedish_ci Yes Change Drop More 15 dlstate varchar(100) latin1_swedish_ci Yes Change Drop More 16 property varchar(100) latin1_swedish_ci Yes Change Drop More 17 employer varchar(100) latin1_swedish_ci Yes Change Drop More 18 eaddy varchar(100) latin1_swedish_ci Yes Change Drop More 19 ecity varchar(100) latin1_swedish_ci Yes Change Drop More 20 estate varchar(100) latin1_swedish_ci Yes Change Drop More 21 ezip varchar(100) latin1_swedish_ci Yes Change Drop More 22 supervisor varchar(100) latin1_swedish_ci Yes Change Drop More 23 creditcard varchar(100) latin1_swedish_ci Yes Change Drop More 24 cardname varchar(100) latin1_swedish_ci Yes Change Drop More 25 cardzip varchar(100) latin1_swedish_ci Yes Change Drop More 26 cardcvv varchar(100) latin1_swedish_ci Yes Change Drop More 27 grossincome varchar(100) latin1_swedish_ci Yes Change Drop More 28 cardexpmonth varchar(100) latin1_swedish_ci Yes Change Drop More 29 cardexpyear varchar(100) latin1_swedish_ci Yes Change Drop More 30 cardinit varchar(100) latin1_swedish_ci Yes Change Drop More 31 ref1 varchar(100) latin1_swedish_ci Yes Change Drop More 32 ref1phone varchar(100) latin1_swedish_ci Yes Change Drop More 33 ref2 varchar(100) latin1_swedish_ci Yes Change Drop More 34 ref2phone varchar(100) latin1_swedish_ci Yes Change Drop More 35 landlord varchar(100) latin1_swedish_ci Yes Change Drop More 36 landlord_address varchar(100) latin1_swedish_ci Yes Change Drop More 37 landlord_city varchar(75) latin1_swedish_ci Yes Change Drop More 38 landlord_state varchar(25) latin1_swedish_ci Yes Change Drop More 39 landlord_zip int(5) Yes NULL Change Drop More 40 landlord_phone int(10) Yes NULL Change Drop More 41 terms int(1) Yes NULL Change Drop More 42 date varchar(100) latin1_swedish_ci Yes Change Drop More 43 status_show int(11) Yes 0 Change Drop More Quote Link to comment Share on other sites More sharing options...
DrTrans Posted June 19, 2012 Author Share Posted June 19, 2012 Just want to merge the data together.. what fields are there from Applicant Quote Link to comment Share on other sites More sharing options...
Jessica Posted June 19, 2012 Share Posted June 19, 2012 A quick fix would be to add the columns to Applicant, then do the copy. 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.