SQL Insert Query With Syntax & Examples

Insert Syntax In SQL With Example, How To Insert Value In SQL, SQL Insert Query With Syntax & Examples

Insert Command In SQL

Description:
This command is used to enter (input) data into the created table.

Syntax:
INSERT INTO
<TableName> (<ColumnName1>,<ColumnName2>)  VALUES(<Expression1>,<Expression2>);

Example:
INSERT INTO
STUDENT(ROLL_NO,NAME,BRANCH,PERCENT)
VALUES(‘CS05111’, ‘AAA’, ‘CO.SC’, 84.45);

Tweet