Sql Query To Insert The Record In The Table By 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 by defining the column name.

After that, we will show the inserted data.

Database

Theme

Output

#	Program	Language
1	Sql Query To use CHECK Constraint	SQL
2	Sql Query To Update Multiple Column	SQL
3	Sql Query to Create View	SQL
4	Sql Query To Use a ' SELECT ' statement with HAVING Clause	SQL
5	Sql Query To use a ' SELECT ' statement with COUNT() function	SQL
6	Sql Query To Retrieve Employees Data	SQL
7	Sql Query to Truncate Table	SQL
8	Sql Case Sensitive Example 4	SQL
9	Sql Query To Update Single Record	SQL
10	Sql Query To Use a Inner Joins	SQL
11	Sql Case Sensitive Example 1	SQL
12	Sql Case Sensitive Example 5	SQL
13	Sql Query To Use a ' SELECT ' statement with IN Clause	SQL
14	Sql Query To Insert The Record In The Table Without Defining The Column Name.	SQL
15	Sql Query To Use a ' SELECT ' statement with LIMIT	SQL
16	Sql Query To Use a ' SELECT ' statement with the MIN() or MAX() function.	SQL
17	Sql Query to retrieve data using Order By in Descending Order	SQL
18	Sql Query To Add Column Using ADD With ALTER Command	SQL
19	Sql Query to use a Not Null Constraint	SQL
20	Sql Case Sensitive Query Without Semicolon	SQL
#	Program	Language