how to insert multiple rows in sql using loop code example

Example 1: SQL Insert Multiple Rows

INSERT INTO StudentTable

( Rollo, Name, Class, Contact )

VALUES ( '1', 'Jonny', '10th', '9856245'  ),

( '2', 'Ronny', '12th', '5421545'  );

Example 2: 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);

Tags:

Sql Example

Related