CODE EXAMPLE FOR SQL

sql add multiple values

INSERT INTO table_name (column_list)
VALUES
    (value_list_1),
    (value_list_2),
    ...
    (value_list_n);

Max number of rows is 1000. Inserting rows returned from a SELECT
is done with

INSERT INTO table_name (column_list)
SELECT ... FROM ... (...rest of select statement...);