1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1(id TINYINT NOT NULL, data CHAR(16), PRIMARY KEY(id)); 3INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle'); 4SELECT * FROM t1 ORDER BY id; 5id data 61 MySQL 72 ROCKS 83 Texas 94 kyle 10UPDATE t1 SET id=id+4 WHERE id=1; 11SELECT * FROM t1 ORDER BY id; 12id data 132 ROCKS 143 Texas 154 kyle 165 MySQL 17DROP TABLE t1; 18CREATE TABLE t1(id SMALLINT NOT NULL, data CHAR(16), PRIMARY KEY(id)); 19INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle'); 20SELECT * FROM t1 ORDER BY id; 21id data 221 MySQL 232 ROCKS 243 Texas 254 kyle 26UPDATE t1 SET id=id+4 WHERE id=1; 27SELECT * FROM t1 ORDER BY id; 28id data 292 ROCKS 303 Texas 314 kyle 325 MySQL 33DROP TABLE t1; 34CREATE TABLE t1(id MEDIUMINT NOT NULL, data CHAR(16), PRIMARY KEY(id)); 35INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle'); 36SELECT * FROM t1 ORDER BY id; 37id data 381 MySQL 392 ROCKS 403 Texas 414 kyle 42UPDATE t1 SET id=id+4 WHERE id=1; 43SELECT * FROM t1 ORDER BY id; 44id data 452 ROCKS 463 Texas 474 kyle 485 MySQL 49DROP TABLE t1; 50CREATE TABLE t1(id INT NOT NULL, data CHAR(16), PRIMARY KEY(id)); 51INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle'); 52SELECT * FROM t1 ORDER BY id; 53id data 541 MySQL 552 ROCKS 563 Texas 574 kyle 58UPDATE t1 SET id=id+4 WHERE id=1; 59SELECT * FROM t1 ORDER BY id; 60id data 612 ROCKS 623 Texas 634 kyle 645 MySQL 65DROP TABLE t1; 66CREATE TABLE t1(id INTEGER NOT NULL, data CHAR(16), PRIMARY KEY(id)); 67INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle'); 68SELECT * FROM t1 ORDER BY id; 69id data 701 MySQL 712 ROCKS 723 Texas 734 kyle 74UPDATE t1 SET id=id+4 WHERE id=1; 75SELECT * FROM t1 ORDER BY id; 76id data 772 ROCKS 783 Texas 794 kyle 805 MySQL 81DROP TABLE t1; 82CREATE TABLE t1(id BIGINT NOT NULL, data CHAR(16), PRIMARY KEY(id)); 83INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle'); 84SELECT * FROM t1 ORDER BY id; 85id data 861 MySQL 872 ROCKS 883 Texas 894 kyle 90UPDATE t1 SET id=id+4 WHERE id=1; 91SELECT * FROM t1 ORDER BY id; 92id data 932 ROCKS 943 Texas 954 kyle 965 MySQL 97DROP TABLE t1; 98