select into

select into, can be used to select record into table(maybe temporary table) or variable.

• select into table

  SQL Server: Temporary tables come in different flavours including, amongst others, local temporary tables (starting with #), global temporary tables (starting with ##), persistent temporary tables (prefixed by TempDB..), and table variables.(starting with (@)

  PostgreSQL

• select into variable|variable list|record name

  Oracle
  MySQL: sql SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; DB2: sql SELECT INTCOL1 INTO MYINTARRAY1[INTCOL2+MYINTVAR+1] FROM T1 WHERE INTCOL1 = MYINTARRAY1[INTCOL2] ;