col_name] ... INTO
INTO syntax enables selected columns to be stored
directly into variables. The query should return a single row.
If the query returns no rows, a warning with error code 1329
No data), and the variable values
remain unchanged. If the query returns multiple rows, error 1172
Result consisted of more than one
row). If it is possible that the statement may
retrieve multiple rows, you can use
to limit the result set to a single row.
SELECT id,data INTO x,y FROM test.t1 LIMIT 1;
User variable names are not case sensitive. See Section 8.4, “User-Defined Variables”.
In the context of
... INTO statements that occur as part of events
executed by the Event Scheduler, diagnostics messages (not only
errors, but also warnings) are written to the error log, and, on
Windows, to the application event log. For additional
information, see Section 18.4.5, “Event Scheduler Status”.