Eine Einführung in
SQL
UPDATE can change an existing record.
SQLite
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to SQLite
none
DB2
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to DB2
none
MS Access
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to MS Access
none
PostgreSQL
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to PostgreSQL
none
Oracle
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to Oracle
none
MS SQL Server
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to MS SQL Server
none
MySQL
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to MySQL
none
Sybase
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to Sybase
none
Mimer SQL
Execute set up
code
DROP TABLE t_peep; CREATE TABLE t_peep (id INTEGER, name VARCHAR(10)); INSERT INTO t_peep VALUES (1, 'Andrew'); INSERT INTO t_peep VALUES (2, 'Gordon');
UPDATE t_peep SET name = 'andy', id=39 WHERE id=1; SELECT * FROM t_peep
Specific to Mimer SQL
none