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

Sharing is caring.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Like This Post?

We have a lot more where that came from?

We only send really good stuff occasionally, promise.

Rajkumar SM

Leave a Comment

Your email address will not be published. Required fields are marked *

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on whatsapp

Recent Posts:

Scroll to Top
API Testing eBook

DOWNLOAD FOR FREE