Question - How can you add several rows in Structured Query Language?
Answer -
We can use the following syntax to add several rows in Structured Query Language:
INSERT INTO table_name (column1, column2,column3...)
VALUES
(value1, value2, value3…..),
(value1, value2, value3….),
...
(value1, value2, value3);
We will add the keywords ‘INSERT INTO’ and enter the table’s name to add values. It will be followed by column lists and adding values for them. Then we will type the keyword ‘VALUE’ and provide the list of values.