Home / server / Questions / 193053
Accepted
Detritus Maximus
Asked: 2010-10-21 09:29:43 +0800 CST

How do I export table "practices" from db1 into db2? How do I do all tables from db1 into db2? Mysql

  • 772

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>
mysql sql export

2 Answers

  1. CREATE TABLE `db2`.`practices` SELECT * FROM `db1`.`practices`
    • 0
  2. Best Answer

    Create new table in DB2 that's a copy of practices in DB1:

    Mysql> USE DB2;
Mysql> CREATE TABLE practices SELECT * FROM DB1.practices;
    • 0