insert into table sql multiple row 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 values into one column sql

INSERT INTO Data ( Col1 ) VALUES
('Hello'),
('World');