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