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 vote219 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
6 votes199 views3 answers
Create database mysql utf8
SQL
0 vote201 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote192 views1 answer
Get who is hired in february in sql
SQL
2 votes200 views1 answer
Revokeprivileges mysql
SQL
0 vote151 views2 answers
Influxdb delete measurement based on date
SQL
2 votes170 views1 answer
Install sqlite npm
SQL
1 vote175 views2 answers
Reset mysqli fetch_arra
SQL
1 vote165 views1 answer
Mysql count words
SQL
1 vote195 views1 answer
Isnull sql server
SQL