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