TABLE FROM V5.0.45 DATABASE (CAUSES ERROR) bu_bpid varchar(9) latin1_swedish_ci YES select,insert,update,references bu_date varchar(8) latin1_swedish_ci YES select,insert,update,references bu_amount varchar(9) latin1_swedish_ci YES select,insert,update,references bu_ssn varchar(9) latin1_swedish_ci YES select,insert,update,references bu_first varchar(25) latin1_swedish_ci YES select,insert,update,references bu_last varchar(25) latin1_swedish_ci YES select,insert,update,references bu_address1 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_address2 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_city varchar(50) latin1_swedish_ci YES select,insert,update,references bu_state varchar(2) latin1_swedish_ci YES select,insert,update,references bu_zip varchar(5) latin1_swedish_ci YES select,insert,update,references bu_phone varchar(10) latin1_swedish_ci YES select,insert,update,references bu_email varchar(50) latin1_swedish_ci YES select,insert,update,references bu_user varchar(50) latin1_swedish_ci YES select,insert,update,references bu_pass varchar(9) latin1_swedish_ci YES select,insert,update,references bu_flags varchar(6) latin1_swedish_ci YES select,insert,update,references bu_stssn varchar(9) latin1_swedish_ci YES (NULL) select,insert,update,references bu_stfirst varchar(25) latin1_swedish_ci YES select,insert,update,references bu_stlast varchar(25) latin1_swedish_ci YES select,insert,update,references bu_staddr1 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_staddr2 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_stcity varchar(50) latin1_swedish_ci YES select,insert,update,references bu_ststate varchar(2) latin1_swedish_ci YES select,insert,update,references bu_stzip varchar(5) latin1_swedish_ci YES select,insert,update,references bu_stphone varchar(10) latin1_swedish_ci YES select,insert,update,references bu_stemail varchar(50) latin1_swedish_ci YES select,insert,update,references bu_stflags varchar(6) latin1_swedish_ci YES select,insert,update,references bu_stgrad varchar(8) latin1_swedish_ci YES select,insert,update,references bu_stdob varchar(8) latin1_swedish_ci YES select,insert,update,references bu_stsex varchar(1) latin1_swedish_ci YES select,insert,update,references bu_stamount varchar(9) latin1_swedish_ci YES select,insert,update,references bu_spid int(11) YES select,insert,update,references bu_spidnew int(11) YES select,insert,update,references bu_stid int(11) YES select,insert,update,references bu_stnew tinyint(4) YES 0 select,insert,update,references CREATE TABLE `_bpsponsorupdate` ( `bu_bpid` varchar(9) default NULL, `bu_date` varchar(8) default NULL, `bu_amount` varchar(9) default NULL, `bu_ssn` varchar(9) default NULL, `bu_first` varchar(25) default NULL, `bu_last` varchar(25) default NULL, `bu_address1` varchar(50) default NULL, `bu_address2` varchar(50) default NULL, `bu_city` varchar(50) default NULL, `bu_state` varchar(2) default NULL, `bu_zip` varchar(5) default NULL, `bu_phone` varchar(10) default NULL, `bu_email` varchar(50) default NULL, `bu_user` varchar(50) default NULL, `bu_pass` varchar(9) default NULL, `bu_flags` varchar(6) default NULL, `bu_stssn` varchar(9) default '(NULL)', `bu_stfirst` varchar(25) default NULL, `bu_stlast` varchar(25) default NULL, `bu_staddr1` varchar(50) default NULL, `bu_staddr2` varchar(50) default NULL, `bu_stcity` varchar(50) default NULL, `bu_ststate` varchar(2) default NULL, `bu_stzip` varchar(5) default NULL, `bu_stphone` varchar(10) default NULL, `bu_stemail` varchar(50) default NULL, `bu_stflags` varchar(6) default NULL, `bu_stgrad` varchar(8) default NULL, `bu_stdob` varchar(8) default NULL, `bu_stsex` varchar(1) default NULL, `bu_stamount` varchar(9) default NULL, `bu_spid` int(11) default NULL, `bu_spidnew` int(11) default NULL, `bu_stid` int(11) default NULL, `bu_stnew` tinyint(4) default '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 STUDENT TABLE (TARGET WERE DATA IS IMPORTED INTO) CREATE TABLE `student` ( `st_stid` int(11) NOT NULL auto_increment, `st_ssn` varchar(9) default NULL, `st_first` varchar(25) default NULL, `st_last` varchar(50) default NULL, `st_address1` varchar(50) default NULL, `st_address2` varchar(50) default NULL, `st_city` varchar(50) default NULL, `st_state` varchar(25) default NULL, `st_zip` varchar(12) default NULL, `st_phonearea` varchar(3) default NULL, `st_phoneexchange` varchar(3) default NULL, `st_phonenumber` varchar(4) default NULL, `st_dob` date default NULL, `st_email` varchar(50) default NULL, `st_graduation` datetime default NULL, `st_source` varchar(45) default NULL, `st_active` tinyint(4) default '1', `st_deleted` tinyint(4) default '0', `st_add` datetime default NULL, `st_dla` datetime default NULL, `st_gender` varchar(1) default NULL, `st_working` tinyint(4) default NULL, `st_gpa` varchar(4) default NULL, `st_satm` varchar(3) default NULL, `st_satr` varchar(3) default NULL, `st_satw` varchar(3) default NULL, `st_act` varchar(4) default NULL, `st_major1` varchar(50) default NULL, `st_smajor1` varchar(50) default NULL, `st_major2` varchar(50) default NULL, `st_smajor2` varchar(50) default NULL, `st_ethnicity` tinyint(4) default NULL, PRIMARY KEY (`st_stid`), UNIQUE KEY `st_stid` (`st_stid`), KEY `st_ssn` (`st_ssn`) ) ENGINE=InnoDB AUTO_INCREMENT=134126 DEFAULT CHARSET=latin1 TABLE FROM V5.0.18 DATABASE (WORKING) bu_bpid varchar(9) latin1_swedish_ci YES select,insert,update,references bu_date varchar(8) latin1_swedish_ci YES select,insert,update,references bu_amount varchar(9) latin1_swedish_ci YES select,insert,update,references bu_ssn varchar(9) latin1_swedish_ci YES select,insert,update,references bu_first varchar(25) latin1_swedish_ci YES select,insert,update,references bu_last varchar(25) latin1_swedish_ci YES select,insert,update,references bu_address1 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_address2 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_city varchar(50) latin1_swedish_ci YES select,insert,update,references bu_state varchar(2) latin1_swedish_ci YES select,insert,update,references bu_zip varchar(5) latin1_swedish_ci YES select,insert,update,references bu_phone varchar(10) latin1_swedish_ci YES select,insert,update,references bu_email varchar(50) latin1_swedish_ci YES select,insert,update,references bu_user varchar(50) latin1_swedish_ci YES select,insert,update,references bu_pass varchar(9) latin1_swedish_ci YES select,insert,update,references bu_flags varchar(6) latin1_swedish_ci YES select,insert,update,references bu_stssn varchar(9) latin1_swedish_ci YES (NULL) select,insert,update,references bu_stfirst varchar(25) latin1_swedish_ci YES select,insert,update,references bu_stlast varchar(25) latin1_swedish_ci YES select,insert,update,references bu_staddr1 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_staddr2 varchar(50) latin1_swedish_ci YES select,insert,update,references bu_stcity varchar(50) latin1_swedish_ci YES select,insert,update,references bu_ststate varchar(2) latin1_swedish_ci YES select,insert,update,references bu_stzip varchar(5) latin1_swedish_ci YES select,insert,update,references bu_stphone varchar(10) latin1_swedish_ci YES select,insert,update,references bu_stemail varchar(50) latin1_swedish_ci YES select,insert,update,references bu_stflags varchar(6) latin1_swedish_ci YES select,insert,update,references bu_stgrad varchar(8) latin1_swedish_ci YES select,insert,update,references bu_stdob varchar(8) latin1_swedish_ci YES select,insert,update,references bu_stsex varchar(1) latin1_swedish_ci YES select,insert,update,references bu_stamount varchar(9) latin1_swedish_ci YES select,insert,update,references bu_spid int(11) YES select,insert,update,references bu_stid int(11) YES select,insert,update,references bu_stnew tinyint(4) YES 0 select,insert,update,references CREATE TABLE `_bpsponsorupdate` ( `bu_bpid` varchar(9) default NULL, `bu_date` varchar(8) default NULL, `bu_amount` varchar(9) default NULL, `bu_ssn` varchar(9) default NULL, `bu_first` varchar(25) default NULL, `bu_last` varchar(25) default NULL, `bu_address1` varchar(50) default NULL, `bu_address2` varchar(50) default NULL, `bu_city` varchar(50) default NULL, `bu_state` varchar(2) default NULL, `bu_zip` varchar(5) default NULL, `bu_phone` varchar(10) default NULL, `bu_email` varchar(50) default NULL, `bu_user` varchar(50) default NULL, `bu_pass` varchar(9) default NULL, `bu_flags` varchar(6) default NULL, `bu_stssn` varchar(9) default '(NULL)', `bu_stfirst` varchar(25) default NULL, `bu_stlast` varchar(25) default NULL, `bu_staddr1` varchar(50) default NULL, `bu_staddr2` varchar(50) default NULL, `bu_stcity` varchar(50) default NULL, `bu_ststate` varchar(2) default NULL, `bu_stzip` varchar(5) default NULL, `bu_stphone` varchar(10) default NULL, `bu_stemail` varchar(50) default NULL, `bu_stflags` varchar(6) default NULL, `bu_stgrad` varchar(8) default NULL, `bu_stdob` varchar(8) default NULL, `bu_stsex` varchar(1) default NULL, `bu_stamount` varchar(9) default NULL, `bu_spid` int(11) default NULL, `bu_stid` int(11) default NULL, `bu_stnew` tinyint(4) default '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `student` ( `st_stid` int(11) NOT NULL auto_increment, `st_ssn` varchar(9) default NULL, `st_first` varchar(25) default NULL, `st_last` varchar(50) default NULL, `st_address1` varchar(50) default NULL, `st_address2` varchar(50) default NULL, `st_city` varchar(50) default NULL, `st_state` varchar(25) default NULL, `st_zip` varchar(12) default NULL, `st_phonearea` varchar(3) default NULL, `st_phoneexchange` varchar(3) default NULL, `st_phonenumber` varchar(4) default NULL, `st_dob` date default NULL, `st_email` varchar(50) default NULL, `st_graduation` datetime default NULL, `st_source` varchar(45) default NULL, `st_active` tinyint(4) default '1', `st_deleted` tinyint(4) default '0', `st_add` datetime default NULL, `st_dla` datetime default NULL, `st_gender` varchar(1) default NULL, `st_working` tinyint(4) default NULL, `st_gpa` varchar(4) default NULL, `st_satm` varchar(3) default NULL, `st_satr` varchar(3) default NULL, `st_satw` varchar(3) default NULL, `st_act` varchar(4) default NULL, `st_major1` varchar(50) default NULL, `st_smajor1` varchar(50) default NULL, `st_major2` varchar(50) default NULL, `st_smajor2` varchar(50) default NULL, `st_ethnicity` int(11) default NULL, PRIMARY KEY (`st_stid`), UNIQUE KEY `st_stid` (`st_stid`), KEY `st_ssn` (`st_ssn`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 And this is the full query that is being used: INSERT INTO student (st_ssn, st_first, st_last, st_address1, st_address2, st_city, st_state, st_zip, st_phonearea, st_phoneexchange, st_phonenumber, st_email,st_add, st_graduation, st_dob, st_gender,st_source) SELECT bu_stssn, min(bu_stfirst), min(bu_stlast), min(bu_staddr1), min(bu_staddr2), min(bu_stcity), min(bu_ststate), min(bu_stzip), min(IF(CHAR_LENGTH(bu_stphone)=10,left(bu_stphone,3),'')), min(IF(CHAR_LENGTH(bu_stphone)=10,mid(bu_stphone,4,3),'')), min(IF(CHAR_LENGTH(bu_stphone)=10,right(bu_stphone,4),'')), trim(min(bu_stemail)), now(), min(IF(CHAR_LENGTH(TRIM(bu_stgrad))=8,bu_stgrad,CONCAT(DATE_FORMAT(DATE_ADD(bu_stdob, INTERVAL 18 YEAR),'%Y'),"0630"))), min(IF(CHAR_LENGTH(TRIM(bu_stdob))=8,bu_stdob,NULL)), min(bu_stsex), 'CTB Import' FROM _BPSponsorUpdate WHERE bu_stid IS NULL and bu_stssn is not null and bu_stssn <> '' GROUP BY bu_stssn,'CTB Import'