CODEWITHSUNDEEP
mysql
EmmyS
EmmyS

Reputation: 12138

mysql error - table name throws undeclared variable

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

Upvotes: 0

Views: 2123

Answers (1)

Vishal
Vishal

Reputation: 12369

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

Read more in this question..

Upvotes: 2

Related Questions