Adding Data To An SQL Table

Assume you have the following table:

CREATE TABLE dog (
  name CHAR(20),
  age INT
);

To add data to it, use the INSERT INTO command.

INSERT INTO dog VALUES ('Sandy', 12);

If you wish to add more than on record at once, separate the values with a comma.

INSERT INTO dog VALUES ('Sandy', 12), ('Odie', 7);