Sql Query To Insert Multiple Records At A Time In The Table

To insert single or multiple records in an already-created table. Then we can use an ' INSERT ' Statement.

First, we will create a user_detail table.

Then we insert multiple records at a time in the table.

After that, we will show the inserted data.

SQL Query
CREATE TABLE user_detail ( id int primary key, name varchar(50) not null, email varchar(50) unique, dateofbirth date ); INSERT INTO user_detail(id,name,email,dateofbirth) VALUES (3,'Fresher bell1','[email protected]','2022-07-02'), (4,'Fresher bell2','[email protected]','2022-09-02'), (5,'Fresher bell3','[email protected]','2022-10-02'), (6,'Fresher bell4','[email protected]','2022-11-02'); SELECT * FROM user_detail;