Results 1 to 6 of 6
Jan 1, 2009, 13:53 #1
importing/exporting multiple tables?
I have three related tables that need data manually edited, I'm using phpMyAdmin to export the tables in CVS excel format for field editing, is there a way to join those tables together for export? Right now they look like this in excel;
id table1 field1
id table2 field1
id table3 field1
I'm having a hard time editing as the tables show up one after the other, I'd like to export them like this;
id table1 field1 table2 field1 table3 field1
01 xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
02 xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
03 xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
how can this be accomplished? and how would i later import the updated fields?
I'm new to SQL and phpMyAdmin I'd really appreciate your help