(mysql.info.gz) SELECT INTO Statement
Info Catalog
(mysql.info.gz) SET Statement
(mysql.info.gz) Variables in Stored Procedures
19.1.6.3 `SELECT ... INTO' Statement
....................................
SELECT COL_NAME[,...] INTO VAR_NAME[,...] TABLE_EXPR
This `SELECT' syntax stores selected columns directly into variables.
Therefore, only a single row may be retrieved. This statement is also
extremely useful when used in combination with cursors.
SELECT id,data INTO x,y FROM test.t1 LIMIT 1;
Info Catalog
(mysql.info.gz) SET Statement
(mysql.info.gz) Variables in Stored Procedures
automatically generated byinfo2html