sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

Syntax error using FROM and INTO @variablename

Open williamdes opened this issue 6 years ago • 0 comments

SELECT CONCAT('CHECKSUM TABLE ', GROUP_CONCAT(table_name), ';') AS statement
FROM information_schema.tables
WHERE table_schema = 'information_schema' INTO @command;

Gives a query syntax error because of INTO @command

Error

Near FROM

williamdes avatar Feb 05 '19 09:02 williamdes