SQL INSERT INTO Statement
In this tutorial we know about the SQL INSERT INTO statement, first talking on Insert Into query, must read Introduction to SQL For Beginners and also know what is SQL Syntax. Also know about the SELECT Statement. With SELECT statement get all records from tables but when we want distinct records or value. So we use SQL SELECT DISTINCT statement. Select statement is also used with where clause and order by statement for conditional and sort the data result set. SQL stands for Structure query language in Relational Database Management System (RDBMS). SQL Syntax is the format in which data save, update, insert with the SQL commands.
What is SQL INSERT INTO statement?
First of all we discuss about database, A database contain table objects, there are many tables or one table in the database. Tables contains data in the form of records in the format of rows and also contains fields called columns. SQL INSERT INTO statement is always used for insert the records in database’s table object. Records is stored in table by rows and columns. New records insert in table with the insert query.
SQL INSERT INTO statement Syntax:
INSERT INTO table_name (column1, column2, …)
VALUES (value1, value2, …);
In this syntax of SQL Insert query, we user table_name as our actual table name and insert data in columns with values w.r.t column. Data always depend on the type of column we used in our table structure.