Insert Multiple Records in Single Query ( Avoid Multiple Insert )

Khargesh Rajput
9y
9.4k
0
0

Blog

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.

index

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

Up Next