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')
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