Sql

insert into items_ver(item_id, item_group, name)
select * from items where item_id=2;

INSERT INTO target(c1, c2)
SELECT source.c1, source.c2
FROM (VALUES
          ('a', 1),
          ('b', 2)
     ) AS source(c1, c2);

insert into TABLENAMEA (A,B,C,D) 
select A,B,C,D from TABLENAMEB

PREVIOUS	NEXT

Code Example
Sql :: sql where time stamp is in between
Sql :: sql left
Sql :: sql server convert to guid
Sql :: how to upper case in sql
Sql :: to_char sql
Sql :: postgresql procedure example
Sql :: sql update multiple columns
Sql :: truncate oracle
Sql :: sqlite show columns
Sql :: to_date postgresql
Sql :: t-sql random number for each row
Sql :: create table from existing table in sql
Sql :: query to find second highest salary
Sql :: add column table pl sql
Sql :: import mysql dump database command line linux
Sql :: mssql-cli usage
Sql :: sql server management studio reset cache
Sql :: auto increment in postgresql
Sql :: psql get last rows
Sql :: change schema in sql server
Sql :: len sql
Sql :: unique in sql server
Sql :: sql if null then string
Sql :: mysql update command
Sql :: insert in sql
Sql :: sql vs nosql or mysql vs mongodb
Sql :: grant create db postgres
Sql :: square in sql
Sql :: order by sql query
Sql :: sql select