Tuesday, May 30, 2017

INSERT statement in RDBMS

The insert statement allows you to insert a single record or multiple record into a table.

Syntax-

INSERT INTO table
(column-1, column-2,......column-n)
VALUES
(value-1, value-2,.....value-n)

Example-

INSERT INTO supplier
(supplier_id, supplier_name)
VALUES
(24553,'IBM')

No comments:

Post a Comment