1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY);
3
INSERT INTO t1 (c1) VALUES(10);
4
INSERT INTO t1 (c1) VALUES(11);
5
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
11
CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY);
12
INSERT INTO t1 (c1) VALUES(10);
13
INSERT INTO t1 (c1) VALUES(11);
14
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
20
CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY);
21
INSERT INTO t1 (c1) VALUES(10);
22
INSERT INTO t1 (c1) VALUES(11);
23
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
29
CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY);
30
INSERT INTO t1 (c1) VALUES(10);
31
INSERT INTO t1 (c1) VALUES(11);
32
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
38
CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY);
39
INSERT INTO t1 (c1) VALUES(10);
40
INSERT INTO t1 (c1) VALUES(11);
41
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
47
CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY);
48
INSERT INTO t1 (c1) VALUES(10);
49
INSERT INTO t1 (c1) VALUES(11);
50
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
56
CREATE TABLE t1(c1 DECIMAL NOT NULL PRIMARY KEY);
57
INSERT INTO t1 (c1) VALUES(10);
58
INSERT INTO t1 (c1) VALUES(11);
59
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
65
CREATE TABLE t1(c1 DEC NOT NULL PRIMARY KEY);
66
INSERT INTO t1 (c1) VALUES(10);
67
INSERT INTO t1 (c1) VALUES(11);
68
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
74
CREATE TABLE t1(c1 FIXED NOT NULL PRIMARY KEY);
75
INSERT INTO t1 (c1) VALUES(10);
76
INSERT INTO t1 (c1) VALUES(11);
77
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
83
CREATE TABLE t1(c1 NUMERIC NOT NULL PRIMARY KEY);
84
INSERT INTO t1 (c1) VALUES(10);
85
INSERT INTO t1 (c1) VALUES(11);
86
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
92
CREATE TABLE t1(c1 DOUBLE NOT NULL PRIMARY KEY);
93
INSERT INTO t1 (c1) VALUES(10);
94
INSERT INTO t1 (c1) VALUES(11);
95
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
101
CREATE TABLE t1(c1 REAL NOT NULL PRIMARY KEY);
102
INSERT INTO t1 (c1) VALUES(10);
103
INSERT INTO t1 (c1) VALUES(11);
104
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
110
CREATE TABLE t1(c1 DOUBLE PRECISION NOT NULL PRIMARY KEY);
111
INSERT INTO t1 (c1) VALUES(10);
112
INSERT INTO t1 (c1) VALUES(11);
113
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;
119
CREATE TABLE t1(c1 FLOAT NOT NULL PRIMARY KEY);
120
INSERT INTO t1 (c1) VALUES(10);
121
INSERT INTO t1 (c1) VALUES(11);
122
INSERT INTO t1 (c1) VALUES(10) ON DUPLICATE KEY UPDATE c1=100;