DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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