INSERT new records

From SQLZoo
Jump to navigation Jump to search

INSERT is used to add records.

schema:scott
DROP TABLE t_peep;
CREATE TABLE t_peep
 (id INTEGER PRIMARY KEY
 ,name VARCHAR(50))
INSERT INTO t_peep VALUES (1, 'andrew');
INSERT INTO t_peep VALUES (2, 'gordon');
SELECT * FROM t_peep
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects