<p>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.</p>

<p>Thanks.</p>

If you just want to copy the contents, you might be looking for
```
select into
```
:
http://www.w3schools.com/Sql/sql_select_into.asp
. This will not create an identical copy though, it will just copy every row from one table to another.