MySQL ERROR 1327 when doing a INTO FROM

Question

What is the problem with this command.

SELECT *  INTO database2.table2 FROM database1.table1;

It returns this error:

ERROR 1327 (42000): Undeclared variable: database2

The goal is to transfer data in table1 to database2.

Duplicate: http://stackoverflow.com/questions/2949653/select-into-and-undeclared-variable-error — A_Sk, Feb 24 '15 at 07:52

score 6 · Accepted Answer · answered Feb 24 '15 at 07:43

6

select ... into is for storing values in variables. See the documenation for more details. What you need is an insert into .. select ..

insert into database2.table2 (select * from database1.table1)

answered Feb 24 '15 at 07:43

Jens

score 3 · Answer 2 · answered Feb 24 '15 at 07:46

3

Use: CREATE TABLE database2.table2 AS select * from database1.table1;

MySQL probably does not support SELECT ... INTO ... FROM syntax.

answered Feb 24 '15 at 07:46

HGF

MySQL 8.0 uses `SELECT ... INTO ... FROM` syntax. See: http://dev.mysql.com/doc/refman/8.0/en/select-into.html – Clomp Oct 01 '22 at 22:18
@Clomp This is for variables not for tables. – HGF Oct 02 '22 at 19:42

score 1 · Answer 3 · answered Feb 24 '15 at 07:46

1

You should use something like that :

INSERT INTO newDatabase.table1 (Column1, Column2)
SELECT column1, column2 FROM oldDatabase.table1;

answered Feb 24 '15 at 07:46

Ufuk Ugur

score 0 · Answer 4 · answered Feb 24 '15 at 07:44

0

Use this query :

 insert into database2.table2 
  select * from database1.table1;

answered Feb 24 '15 at 07:44

Sagar Joon

score 0 · Answer 5 · edited May 23 '17 at 10:34

0

If those two databases are not connected to each other, you should think about that first.

Connect two databases

Use Linked Server for SQL Server.
To know about how to create a linked server, See this link.

Then use the query:

insert into database2.table2 
    select * from database1.table1;

The syntax is:

INSERT INTO ToTableName 
    SELECT */ColNames FROM FromTableName

edited May 23 '17 at 10:34

Community

answered Feb 24 '15 at 07:44

Raging Bull

5 Answers5