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; Quote 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") Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.