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 vote309 views1 answer
Replace \n sql
SQL
2 votes303 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote328 views1 answer
Influxdb export to csv
SQL
0 vote319 views1 answer
Find and replace database table phpmyadmin
SQL
1 vote313 views1 answer
Rermove categories woocommerce sql
SQL
1 vote324 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
1 vote310 views1 answer
Mysql sort by date column
SQL
1 vote344 views1 answer
Primary key with prefix sql
SQL
0 vote364 views3 answers
Characters found after end of sql statement
SQL
13 votes326 views2 answers
Sqlite rename table
SQL