sql copy 表到mysql,SQL将表从一个数据库复制到另一个数据库

I need to copy a table from one database to another. So I tried to query in SqlFiddle as follows but getting error

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

Error:

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.

解决方案

You could also use mysqldump to dump a table into another database:

mysqldump -u -p | mysql -u -p

Of course the second database must then first be created, which can be done using a command like:

mysql -u -p -e"CREATE DATABASE "