• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

Append content of one table to another

How do I append content of one table to another? They don't identical  structure but they have the same number of fields that I need to merge.

I'm tryng to do it using SSH to the server.
0
carloslaso
Asked:
carloslaso
  • 3
  • 2
1 Solution
 
arnoldCommented:
are the tables within the same database or are you doing it accross databases as well as accross tables?


mysql -u root -p

insert into <newtable> (select column1,column2, column3,... from old table);
0
 
carloslasoAuthor Commented:
Is that going to copy the information into the columns? All of the columns on table1 exist on table1 on the other database but has more columns.

I need to copy the information that exist on table1 to table1 on the other database and leave the columns that do not exist on the other database blank.
0
 
arnoldCommented:
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

Your best bet might be to export the data from one and then import it into the other.

Are you familiar with perl or anyother programming language?

The columns you select will have to match the order and datatype of the one into which you are inserting.
you could specify the column order
insert into database.table (database.column1,......)  (select (1column, 2column, .....) from database2.table where );

0
 
carloslasoAuthor Commented:
The order and the datatype match but the table on one database has 24 fields, the table on the other database has 29 fields, the 5 extra fields are at the bottom/end of the table.

No, I'm not familiar with any programming languages :-/
0
 
arnoldCommented:
Your select statement needs to use the columns in the order in which they exist in the table into which you want the data added.
http://ariejan.net/2008/11/27/export-csv-directly-from-mysql
You can then do the reverse to import
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now