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

Question

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>

Why are you asking first for one table then for all tables? Is there a specific issue you're working on or is this something like a homework problem? — Bart Silverstrim
– Bart Silverstrim, Commented Oct 20, 2010 at 17:33
@Bartimus: I anticipate doing both in the near future and thought I'd avoid doing 2 separate questions. — Detritus Maximus
– Detritus Maximus, Commented Oct 21, 2010 at 12:40

Bryan White · Accepted Answer · 2010-10-20 18:12:04Z

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

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

Slashterix · Accepted Answer · 2010-10-20 18:41:58Z

0

CREATE TABLE `db2`.`practices` SELECT * FROM `db1`.`practices`

answered Oct 20, 2010 at 18:03

6121 gold badge5 silver badges19 bronze badges

2 Answers 2