Jago6060 Posted August 17, 2009 Share Posted August 17, 2009 TableA: native data TableB: client data TableA.fields!=TableB.fields Is there a way(on import) to change the field names of TableB to match those in TableA? Something like... INSERT INTO TableA(project_id)VALUES('project_id="TableB.Project ID"') FROM FILE project.csv; Link to comment https://forums.phpfreaks.com/topic/170722-solved-alias-field-names-on-import/ Share on other sites More sharing options...
onedumbcoder Posted August 17, 2009 Share Posted August 17, 2009 INSERT INTO tableA(project_id) (SELECT "Project ID" FROM tableB WHERE "Project ID"=tableA.project_id INTO OUTFILE "project.csv") Link to comment https://forums.phpfreaks.com/topic/170722-solved-alias-field-names-on-import/#findComment-900441 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.