Eine Einführung in
SQL
INSERT is used to add records.
SQLite
Execute tidy up
code
silently
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
Specific to SQLite
none
DB2
Execute tidy up
code
silently
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
Specific to DB2
none
MS Access
Execute tidy up
code
silently
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
Specific to MS Access
none
PostgreSQL
Execute tidy up
code
silently
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
Specific to PostgreSQL
none
Oracle
Execute tidy up
code
silently
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
Specific to Oracle
none
MS SQL Server
Execute tidy up
code
silently
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
Specific to MS SQL Server
none
MySQL
Execute tidy up
code
silently
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
Specific to MySQL
none
Sybase
Execute tidy up
code
silently
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
Specific to Sybase
none
Mimer SQL
Execute tidy up
code
silently
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
Specific to Mimer SQL
none