Undeclared variable error while using sql into

Question

Please tell me that why am i getting error and what should i do to get result.

Tables in my database

+--------------------+
| Tables_in_practice |
+--------------------+
| employee           |
| employee_duplicate |
| employee_record    |
+--------------------+

3 rows in set (0.00 sec)

QUERY

select *
into employee_duplicate
from employee;

ERROR 1327 (42000): Undeclared variable: employee_duplicate

To format the table/code/error correctly, please add 4 leading space to each line of the table. Thanks! — user6250760
– user6250760, Commented Nov 11, 2017 at 14:03
Possible duplicate of SELECT INTO and "Undeclared variable" error — C3roe
– C3roe, Commented Nov 11, 2017 at 14:06

Gordon Linoff · Accepted Answer · 2017-11-11 14:06:47Z

0

In MySQL, you cannot set the entire row to a variable. Perhaps you just want to return the column:

select employee_duplicate
from employee;

If you want to set a variable, you can do:

select @employee_duplicate := employee_duplicate
from employee;

Although you can use into, most people find the := syntax simpler to follow and to write.

answered Nov 11, 2017 at 14:06

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hemant Lakhotiya Over a year ago

I do not want to set a variable .I wanna transfer data from one table to another table by using select......into statement.

Collectives™ on Stack Overflow

Undeclared variable error while using sql into

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related