Skip to content

Syntax error using FROM and INTO @variablename #225

Open
@williamdes

Description

@williamdes
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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions