Sql Query To Insert The Record In The Table Without Defining The Column Name.


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 the record in the table without defining the column name.

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 VALUES (1,'Fresherbell','[email protected]','2021-02-01'); SELECT * FROM user_detail;
Output