Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Select Into Mysql statement

Example of Select Into Mysql Statement:

SELECT id,data INTO x,y FROM test.t1 LIMIT 1;
SELECT T.xname,id INTO newname,xid
FROM table1 T where ...
SELECT newname;

Example of Mysql Select Into


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