Adding records in table using SQL

Hi everyone,
Is it possible to add multiple records in a table under one clause?
Thanks in advance!

@viciouscode, yes you can.

How you do it may depend on your DBMS though. If you are using SQLite, you simply use the INSERT INTO table VALUES syntax, but after the VALUES keyword, you provide each row of values inside parentheses and separated by commas. For more information, see the official documentation here and an example here.

Wow this is great! Thank you for the insights. :smiley: