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

3 votes233 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
3 votes272 views2 answers
Tsql join multiple record in one string
SQL
3 votes264 views1 answer
Sql server version query
SQL
10 votes267 views4 answers
How to alter table name in mysql
SQL
0 vote309 views1 answer
Get substract count sql
SQL
0 vote269 views1 answer
Sql select all records from all tables where not empty
SQL
2 votes268 views2 answers
Mysql user access to database
SQL
-2 votes290 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote265 views1 answer
Mysql update even / odd rows
SQL
2 votes263 views3 answers
Current month mysql query
SQL