Insert all in sql

INSERT ALL  
  INTO table_name (column1, column2, column_n) VALUES (expr1, expr2, expr_n)  
  INTO table_name(column1, column2, column_n) VALUES (expr1, expr2, expr_n)  
  INTO table_name (column1, column2, column_n) VALUES (expr1, expr2, expr_n)  
SELECT * FROM dual;

Add multiple row table pl sql

INSERT INTO real_table_name (person_id, given_name, family_name, title) 
  WITH temp_table AS ( 
    SELECT 4, 'Ruth',     'Fox',      'Mrs'    FROM dual UNION ALL 
    SELECT 5, 'Isabelle', 'Squirrel', 'Miss'   FROM dual UNION ALL 
    SELECT 6, 'Justin',   'Frog',     'Master' FROM dual UNION ALL 
    SELECT 7, 'Lisa',     'Owl',      'Dr'     FROM dual 
  ) 
  SELECT * FROM temp_table

Similar codes

0 vote145 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote164 views1 answer
How to show index type in postgresql
SQL
0 vote157 views1 answer
Sql select sum group by id laravel join
SQL
0 vote132 views1 answer
First mysql
SQL
0 vote128 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote157 views1 answer
Load mysql dumb
SQL
1 vote134 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
7 votes138 views3 answers
Sql get last inserted row
SQL
10 votes154 views4 answers
Join multiple tables in sql
SQL
0 vote153 views2 answers
How to install mssql on mac
SQL