Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql insert multiple rows based on select

INSERT INTO table1 (col1, col2, col3, col4, col5) 
SELECT col1,col2,col3,col4,col5 
FROM table2 t2 
WHERE t2.val2 IN (MULTIPLE VALUES) 
AND (Another Conditional);
Comment

PREVIOUS NEXT
Code Example
Sql :: online sql compiler 
Sql :: oracle insert multiple rows into same table 
Sql :: like postgres 
Sql :: cardinality example sql 
Sql :: group_concat sql server 
Sql :: how to link java and mysql 
Sql :: mysql update one table from another table multiple columns 
Sql :: postgresql comandos basicos 
Sql :: aliasing in sql 
Sql :: in sqlalchemy 
Sql :: insert overwrite table in mysql in nifi 
Sql :: install sql server windows 10 
Sql :: mysql case sensitive ? 
Sql :: decode plsql 
Sql :: order child below the parent in mysqli 
Sql :: oracle sql winter time change 
Sql :: sql mod even odd 
Sql :: oracle synonym package dblink 
Sql :: what does the -p flag do in mysql cli 
Sql :: create relationship with betwen two tables in postgersql 
Sql :: how to innjert in other database 
Sql :: mysql conf.d exampel 
Sql :: sql fetch next 10 rows pdo 
Sql :: create database like 
Sql :: spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition. 
Sql :: oracle sql date summer time 
Sql :: get all databases and their tables without primary key mysql 
Sql :: SQL Create Named CHECK Constraint 
Sql :: conectar base de datos mysql con java 
Sql :: Update All tables COLLATE DATABASE_DEFAULT 
ADD CONTENT
Topic
Content
Source link
Name
5+7 =