SQL Query to copy records from one table to another table

[leojafree]

Hi All,

What is the sql query in mysql which copies all records from one table to another table within a database...? and query that copies records from one table to another that belongs to a different database...

Regards,
Leo

[raf]

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

from one db to another, you ususally create a dumpfile of that table and then run it against the target db.