select into

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

• select into table

  SQL Server/Sybase: 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

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