Moving Data from one table to another in SQL

[sicollier]

Hi Guys,

I need to run a sql query to move 5 coloums of data to a bew table from 6months ago. These coloumns are
C1 (int)
C2 (varchar)
C3 (varchar)
C4 (text)
Datetime (timestamp)

I'm new to this, I've been looking at the replace command but don't think thats correct can you help?

Kind Regards

 

[sleipnir214]

You wouldn't be doing a replace, would you? Aren't you selecting records from the old table and inserting them into the new?

If you, you probably want to take a look at MySQL's INSERT...SELECT command:

http://www.mysql.com/doc/en/INSERT_SELECT.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[parkers]

one way although potentially dangerous would be to perform a 'mysqldump' on the table to produce a backup '.sql' file then 'LOAD DATA' into the destination table.

Please note the backup sql would need to be edited to remove any DROP TABLE references !! and also the source table name for the new data to be inserted to.

Other than that write a simple script (OS dependent) that reads in the required fields and populates to the destination dB table ... perl would be the ideal for this task.