mysql - Sql 将表从一个数据库复制到另一个数据库

Question

我需要将一个表从一个数据库复制到另一个数据库。所以我尝试在 SqlFiddle 中查询如下但出现错误

CREATE TABLE ForgeRock
    (`id` int, `productName` varchar(7), `description` varchar(55))
;

INSERT INTO ForgeRock
    (`id`, `productName`, `description`)
VALUES
    (1, 'OpenIDM', 'Platform for building enterprise provisioning solutions'),
    (2, 'OpenAM', 'Full-featured access management'),
    (3, 'OpenDJ', 'Robust LDAP server for Java')
;


CREATE TABLE ForgeRock1 AS SELECT * FROM ForgeRock

错误:

DDL and DML statements are not allowed in the query panel for MySQL; only SELECT statements are allowed. Put DDL and DML in the schema panel.

Answer 1

您还可以使用 mysqldump 将表转储到另一个数据库中:

mysqldump -u<user> -p<password> <first_database> <table_name> | mysql -u<user> -p<password> <second_database>

当然必须首先创建第二个数据库，这可以使用如下命令完成:

mysql -u<user> -p<password> -e"CREATE DATABASE <second_database>"