how to insert multiple value into sql code example
Example 1: insert multiple rows in sql.
INSERT INTO table (col1, col2, col3)
VALUES
(row1_val1, row1_val2, row1_val3),
(row2_val1, row2_val2, row2_val3),
(row3_val1, row3_val2, row3_val3);
Example 2: insert multiple values into one column sql
INSERT INTO Data ( Col1 ) VALUES
('Hello'),
('World');