Im using the following query with LOAD DATA INFILE:
"LOAD DATA LOCAL INFILE 'file.csv' INTO table mgap_export FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 3 LINES (@dummy,@dummy,@dummy,@dummy,Full_Name,gt_accountMgrID,Email_Address,mgap_ska_id,@gtdashboardLink, @gt_rankingLink, @gt_analyticsLink) SET gtdashboardLink=CONCAT('http://www.url.com/logind.php?id=',gt_accountMgrID), SET gt_rankingLink=CONCAT('http://www.url.com/logind.php?id=',gt_accountMgrID)";
If I remove the last variable the query works just fine, but I keep getting a syntax error when I leave it in.
Can anyone see where Ive gone wrong? All columns and names have been verifed to NOT be the issue. I know it has to be one of those simple issues that you cannot see until you post it and feel like an idiot when someone else points it out, but, so be it!