Search
 
SCRIPT & CODE EXAMPLE
 

SQL

insert pg result of select

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

PREVIOUS NEXT
Code Example
Sql :: désinstaller postgresql linux 
Sql :: oracle sql group by date year 
Sql :: fetch first 5 characters of the string in sql 
Sql :: where clause for child record apex 
Sql :: mysql db size 
Sql :: data directory postgresql 
Sql :: create table with select 
Sql :: mysql select column where has non int values 
Sql :: oracle exceeded simultaneous sessions_per_user limit 
Sql :: sql update table based on another table 
Sql :: mysql remote connection command line 
Sql :: create function in postgresql 
Sql :: purge undo tablespace usage 
Sql :: convert date to datetime sql 
Sql :: sql add column int nullable 
Sql :: postgres autoincrement primary key 
Sql :: vacuum table postgres 
Sql :: mysql delete user if exists 
Sql :: null column to 0 in mysql 
Sql :: sqlite show table definition 
Sql :: order by oracle 
Sql :: mysql select if empty result 
Sql :: sql not equal multiple columns 
Sql :: How to Find Duplicate Values in a SQL Table 
Sql :: mysql add text to existing field 
Sql :: SQL Count UNIQUE Rows 
Sql :: how to truncate all table in mysql workbench 
Sql :: postgres json to string 
Sql :: enable constraint in sql 
Sql :: phpmyadmin password root 
ADD CONTENT
Topic
Content
Source link
Name
8+3 =