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

Rajkumar SM is a founder of SoftwareTestingMaterial. He is a certified Software Test Engineer by profession and blogger & youtuber by choice. He has an extensive experience in the field of Software Testing. He writes here about Software Testing which includes both Manual and Automation Testing. He loves to be with his wife and cute little kid 'Freedom'.

Leave a Comment

Share via
Copy link
Powered by Social Snap