1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(id TINYINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
3
INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
4
SELECT * FROM t1 ORDER BY id;
10
UPDATE t1 SET id=id+4 WHERE id=1;
11
SELECT * FROM t1 ORDER BY id;
18
CREATE TABLE t1(id SMALLINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
19
INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
20
SELECT * FROM t1 ORDER BY id;
26
UPDATE t1 SET id=id+4 WHERE id=1;
27
SELECT * FROM t1 ORDER BY id;
34
CREATE TABLE t1(id MEDIUMINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
35
INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
36
SELECT * FROM t1 ORDER BY id;
42
UPDATE t1 SET id=id+4 WHERE id=1;
43
SELECT * FROM t1 ORDER BY id;
50
CREATE TABLE t1(id INT NOT NULL, data CHAR(16), PRIMARY KEY(id));
51
INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
52
SELECT * FROM t1 ORDER BY id;
58
UPDATE t1 SET id=id+4 WHERE id=1;
59
SELECT * FROM t1 ORDER BY id;
66
CREATE TABLE t1(id INTEGER NOT NULL, data CHAR(16), PRIMARY KEY(id));
67
INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
68
SELECT * FROM t1 ORDER BY id;
74
UPDATE t1 SET id=id+4 WHERE id=1;
75
SELECT * FROM t1 ORDER BY id;
82
CREATE TABLE t1(id BIGINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
83
INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
84
SELECT * FROM t1 ORDER BY id;
90
UPDATE t1 SET id=id+4 WHERE id=1;
91
SELECT * FROM t1 ORDER BY id;