mysql error - table name throws undeclared variable

Question

I'm trying to back up some records to a separate table in the same database using phpMyAdmin. Here's the query and the error it's throwing. Both tables do exist and are spelled correctly; I copied and pasted the table names directly from their structure page. Any ideas why I'm getting this error?

SELECT *
INTO `arrc_VoucherBAK`
FROM `arrc_Voucher`
WHERE ActivatedDT LIKE "2010-11-10%"
AND BalanceInit IS NOT NULL


MySQL said: Documentation
#1327 - Undeclared variable: arrc_VoucherBAK

possible duplicate - http://stackoverflow.com/questions/2949653/select-into-and-undeclared-variable-error — Vishal, Nov 23 '10 at 18:38

score 2 · Accepted Answer · edited May 23 '17 at 11:56

2

MySQL does not support the SELECT ... INTO ... syntax.

Read more in this question..

edited May 23 '17 at 11:56

Community

1
1

answered Nov 23 '10 at 18:36

Vishal

12,133
17
82
128

Thank you! Too much switching between systems; I can't remember which supports what. – EmmyS Nov 23 '10 at 18:42

mysql error - table name throws undeclared variable

1 Answers1