Database - Introduction to SQL - Discussion

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

It is possible to write the INSERT INTO statement in two forms.

The first form doesn't specify the column names where the data will be inserted, only their values:
1.INSERT INTO table_name
VALUES (value1, value2, value3,...)
2.The second form specifies both the column names and the values to be inserted:
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

We can use insert command to insert data in a table.

Syntax:
INSERT INTO <TABLE NAME> (FIELD1,FILED2,FIELD3) VALUES (VALUE1,VALUE2,VALUE3);

EXAMPLE:
INSERT INTO student(stu_id,name,total) values(101,'Jitu',120);

We can add values into table using insert keyword.
ex:create table emp(name varchar2(20),age number(20)));
it will create emp table and now insert values into this table using fallowing insert query syntax:
insert into <tablename> values('if string or date',number);

Ex:insert into emp values('nani',25);

Add any row in a database by using INSERT key word accessing values by using & symbol it address the values of rows.

Insert is a keyword in order to add the new row.

Insert command is only add a row in a table.

It's a keyword.

Insert into <table_name> values("&ColumnName1","&ColumnName2");

Example of inserting a row as follows:

INSERT INTO table_name VALUES ('FOR STRINGS',FOR NUMERIC VALUES);

In implicit insertion we insert specific field values:
The syntax is:
insert into <tablename>(list of columns) values(list of values);

In explicit insertion we insert all field values:
The syntax is:
insert into <tablename>values(list of values);