Adding Data To An SQL Table

Databases

03/05/2021


Assume you have the following table:

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

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

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

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

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

WRITTEN BY

Code and stuff