Insert Multiple Records in Single Query ( Avoid Multiple Insert )

In this blog you will learn how to Insert Multiple Records in Single Query.

I have a table tbltest with 3 columns id, name, email.

If, I have to insert 4 records or more then i will write 4 insert queries to save records.

Like below screen.



And result will be 1 rows effected for each query.

We can avoid using multiple statements like as below in single statement.



Here we can use single statement and output is 4 rows effected.

I have shared the things which I have found new to me and will be helpful to others.

Thanks