How do I export table "practices" from db1 into db2? How do I do all tables from db1 into db2?
With Mysql, fill in the blank. What do I type at the prompt:
Mysql>
How do I export table "practices" from db1 into db2? How do I do all tables from db1 into db2?
With Mysql, fill in the blank. What do I type at the prompt:
Mysql>
Create new table in DB2 that's a copy of practices in DB1:
Mysql> USE DB2;
Mysql> CREATE TABLE practices SELECT * FROM DB1.practices;