1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 TINYINT NULL UNIQUE);
3
INSERT INTO t1 (c1) VALUES(10);
4
INSERT INTO t1 (c1) VALUES(11);
5
INSERT INTO t1 (c1) VALUES(10);
6
ERROR 23000: Duplicate entry '10' for key 'c1'
12
CREATE TABLE t1(c1 SMALLINT NULL UNIQUE);
13
INSERT INTO t1 (c1) VALUES(10);
14
INSERT INTO t1 (c1) VALUES(11);
15
INSERT INTO t1 (c1) VALUES(10);
16
ERROR 23000: Duplicate entry '10' for key 'c1'
22
CREATE TABLE t1(c1 MEDIUMINT NULL UNIQUE);
23
INSERT INTO t1 (c1) VALUES(10);
24
INSERT INTO t1 (c1) VALUES(11);
25
INSERT INTO t1 (c1) VALUES(10);
26
ERROR 23000: Duplicate entry '10' for key 'c1'
32
CREATE TABLE t1(c1 INT NULL UNIQUE);
33
INSERT INTO t1 (c1) VALUES(10);
34
INSERT INTO t1 (c1) VALUES(11);
35
INSERT INTO t1 (c1) VALUES(10);
36
ERROR 23000: Duplicate entry '10' for key 'c1'
42
CREATE TABLE t1(c1 INTEGER NULL UNIQUE);
43
INSERT INTO t1 (c1) VALUES(10);
44
INSERT INTO t1 (c1) VALUES(11);
45
INSERT INTO t1 (c1) VALUES(10);
46
ERROR 23000: Duplicate entry '10' for key 'c1'
52
CREATE TABLE t1(c1 BIGINT NULL UNIQUE);
53
INSERT INTO t1 (c1) VALUES(10);
54
INSERT INTO t1 (c1) VALUES(11);
55
INSERT INTO t1 (c1) VALUES(10);
56
ERROR 23000: Duplicate entry '10' for key 'c1'
62
CREATE TABLE t1(c1 DECIMAL NULL UNIQUE);
63
INSERT INTO t1 (c1) VALUES(10);
64
INSERT INTO t1 (c1) VALUES(11);
65
INSERT INTO t1 (c1) VALUES(10);
66
ERROR 23000: Duplicate entry '10' for key 'c1'
72
CREATE TABLE t1(c1 DEC NULL UNIQUE);
73
INSERT INTO t1 (c1) VALUES(10);
74
INSERT INTO t1 (c1) VALUES(11);
75
INSERT INTO t1 (c1) VALUES(10);
76
ERROR 23000: Duplicate entry '10' for key 'c1'
82
CREATE TABLE t1(c1 FIXED NULL UNIQUE);
83
INSERT INTO t1 (c1) VALUES(10);
84
INSERT INTO t1 (c1) VALUES(11);
85
INSERT INTO t1 (c1) VALUES(10);
86
ERROR 23000: Duplicate entry '10' for key 'c1'
92
CREATE TABLE t1(c1 NUMERIC NULL UNIQUE);
93
INSERT INTO t1 (c1) VALUES(10);
94
INSERT INTO t1 (c1) VALUES(11);
95
INSERT INTO t1 (c1) VALUES(10);
96
ERROR 23000: Duplicate entry '10' for key 'c1'
102
CREATE TABLE t1(c1 DOUBLE NULL UNIQUE);
103
INSERT INTO t1 (c1) VALUES(10);
104
INSERT INTO t1 (c1) VALUES(11);
105
INSERT INTO t1 (c1) VALUES(10);
106
ERROR 23000: Duplicate entry '10' for key 'c1'
112
CREATE TABLE t1(c1 REAL NULL UNIQUE);
113
INSERT INTO t1 (c1) VALUES(10);
114
INSERT INTO t1 (c1) VALUES(11);
115
INSERT INTO t1 (c1) VALUES(10);
116
ERROR 23000: Duplicate entry '10' for key 'c1'
122
CREATE TABLE t1(c1 DOUBLE PRECISION NULL UNIQUE);
123
INSERT INTO t1 (c1) VALUES(10);
124
INSERT INTO t1 (c1) VALUES(11);
125
INSERT INTO t1 (c1) VALUES(10);
126
ERROR 23000: Duplicate entry '10' for key 'c1'
132
CREATE TABLE t1(c1 FLOAT NULL UNIQUE);
133
INSERT INTO t1 (c1) VALUES(10);
134
INSERT INTO t1 (c1) VALUES(11);
135
INSERT INTO t1 (c1) VALUES(10);
136
ERROR 23000: Duplicate entry '10' for key 'c1'