SQL Insert Query – SQL TUTORIAL | Software Testing Material

SQL Insert Query:

The SQL INSERT INTO statement is used to insert new records in a table.

Syntax:

Here, column_name_1, column_name_2,…column_name_N are the names of the columns in the table into which you want to insert data.

Example:

Following statements would create three records in SCOREBOARD table:

SQL Insert

Example To Insert Data only in a specified column using SQL Insert Query:

In the next tutorial, we will see How To UPDATE Data in a Table in SQL

Check out the complete SQL Tutorial by clicking on below link:

SQL Tutorial – Complete

Get our latest blog posts delivered to your inbox

Subscribe and get popular blog posts about software testing industry.

Rajkumar

Leave a Comment

Share via
Copy link
Powered by Social Snap