SQL Command for copying table

Question

What is the SQL command to copy a table from one database to another database? I am using MySQL and I have two databases x and y. Suppose I have a table in x called a and I need to copy that table to y database. Sorry if the question is too novice.

Thanks.

Answer 1

If the target table doesn't exist....

CREATE TABLE dest_table AS (SELECT * FROM source_table);

If the target table does exist

INSERT INTO dest_table (SELECT * FROM source_table);

Caveat: Only tested in Oracle