Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql copy table1 to table2

INSERT INTO TARGET_TABLE (`col1_`,`col2_`) SELECT `col1`,`col2` FROM SOURCE_TABLE WHERE `foo`=1
Comment

PREVIOUS NEXT
Code Example
Sql :: sql server loop over query 
Sql :: alter table drop column 
Sql :: oracle user quota on tablespace 
Sql :: mysql mediumint max value 
Sql :: sql string_agg 
Sql :: laravel paginate raw sql 
Sql :: creating a view sql 
Sql :: oracle sql day of month from date 
Sql :: oracle cannot access v$session 
Sql :: drop all foreign key constraints mysql 
Sql :: sql query inline if 
Sql :: psql import backup file for windows 
Sql :: view linked servers sql 
Sql :: how to drop a trigger in postgresql 
Sql :: mysql number format 
Sql :: PL SQL MODIFY COLUMN NME 
Sql :: backup ms sql database table data to file 
Sql :: how to define a composite primary key in sql 
Sql :: oracle asynchronous query 
Sql :: ORACLE SHOW AVAILABLE DB LINK 
Sql :: if not exists insert sql 
Sql :: sql server date format dd/mm/yyyy 
Sql :: date in where on datetime column clause mysql 
Sql :: mysql remote connection command line 
Sql :: mysql does sentence contain word 
Sql :: t sql get foreign key 
Sql :: oracle auto_increment 
Sql :: ubuntu reset mysql root password 
Sql :: get only structure database mysql 
Sql :: mysql add root password 
ADD CONTENT
Topic
Content
Source link
Name
4+1 =