Eine Einführung in
SQL
INSERT: Not all fields need be specified. Default values may be specified in the CREATE TABLE clause - otherwise NULL is used.
SQLite
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to SQLite
none
DB2
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to DB2
none
MS Access
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to MS Access
none
PostgreSQL
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to PostgreSQL
none
Oracle
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to Oracle
none
MS SQL Server
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to MS SQL Server
none
MySQL
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to MySQL
none
Sybase
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to Sybase
none
Mimer SQL
Execute tidy up
code
silently
DELETE FROM t_peep WHERE id=99
INSERT INTO t_peep (id) VALUES (99); SELECT * FROM t_peep
Specific to Mimer SQL
none