reference manuals search engine

MySQL Reference Manual - 4.0.20

19.1.6.3 SELECT ... INTO Statement

SELECT col_name[,...] INTO var_name[,...] table_expression

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;

This document was generated on July, 26 2004 using texi2html 1.70.