1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 3INSERT INTO t1 (c1) VALUES(10); 4INSERT INTO t1 (c1) VALUES(11); 5INSERT IGNORE INTO t1 (c1) VALUES(10); 6Warnings: 7Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 8SELECT * FROM t1; 9c1 1010 1111 12DROP TABLE t1; 13CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 14INSERT INTO t1 (c1) VALUES(10); 15INSERT INTO t1 (c1) VALUES(11); 16INSERT IGNORE INTO t1 (c1) VALUES(10); 17Warnings: 18Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 19SELECT * FROM t1; 20c1 2110 2211 23DROP TABLE t1; 24CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 25INSERT INTO t1 (c1) VALUES(10); 26INSERT INTO t1 (c1) VALUES(11); 27INSERT IGNORE INTO t1 (c1) VALUES(10); 28Warnings: 29Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 30SELECT * FROM t1; 31c1 3210 3311 34DROP TABLE t1; 35CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 36INSERT INTO t1 (c1) VALUES(10); 37INSERT INTO t1 (c1) VALUES(11); 38INSERT IGNORE INTO t1 (c1) VALUES(10); 39Warnings: 40Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 41SELECT * FROM t1; 42c1 4310 4411 45DROP TABLE t1; 46CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 47INSERT INTO t1 (c1) VALUES(10); 48INSERT INTO t1 (c1) VALUES(11); 49INSERT IGNORE INTO t1 (c1) VALUES(10); 50Warnings: 51Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 52SELECT * FROM t1; 53c1 5410 5511 56DROP TABLE t1; 57CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 58INSERT INTO t1 (c1) VALUES(10); 59INSERT INTO t1 (c1) VALUES(11); 60INSERT IGNORE INTO t1 (c1) VALUES(10); 61Warnings: 62Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 63SELECT * FROM t1; 64c1 6510 6611 67DROP TABLE t1; 68CREATE TABLE t1(c1 DECIMAL NOT NULL PRIMARY KEY); 69INSERT INTO t1 (c1) VALUES(10); 70INSERT INTO t1 (c1) VALUES(11); 71INSERT IGNORE INTO t1 (c1) VALUES(10); 72Warnings: 73Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 74SELECT * FROM t1; 75c1 7610 7711 78DROP TABLE t1; 79CREATE TABLE t1(c1 DEC NOT NULL PRIMARY KEY); 80INSERT INTO t1 (c1) VALUES(10); 81INSERT INTO t1 (c1) VALUES(11); 82INSERT IGNORE INTO t1 (c1) VALUES(10); 83Warnings: 84Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 85SELECT * FROM t1; 86c1 8710 8811 89DROP TABLE t1; 90CREATE TABLE t1(c1 FIXED NOT NULL PRIMARY KEY); 91INSERT INTO t1 (c1) VALUES(10); 92INSERT INTO t1 (c1) VALUES(11); 93INSERT IGNORE INTO t1 (c1) VALUES(10); 94Warnings: 95Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 96SELECT * FROM t1; 97c1 9810 9911 100DROP TABLE t1; 101CREATE TABLE t1(c1 NUMERIC NOT NULL PRIMARY KEY); 102INSERT INTO t1 (c1) VALUES(10); 103INSERT INTO t1 (c1) VALUES(11); 104INSERT IGNORE INTO t1 (c1) VALUES(10); 105Warnings: 106Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 107SELECT * FROM t1; 108c1 10910 11011 111DROP TABLE t1; 112CREATE TABLE t1(c1 DOUBLE NOT NULL PRIMARY KEY); 113INSERT INTO t1 (c1) VALUES(10); 114INSERT INTO t1 (c1) VALUES(11); 115INSERT IGNORE INTO t1 (c1) VALUES(10); 116Warnings: 117Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 118SELECT * FROM t1; 119c1 12010 12111 122DROP TABLE t1; 123CREATE TABLE t1(c1 REAL NOT NULL PRIMARY KEY); 124INSERT INTO t1 (c1) VALUES(10); 125INSERT INTO t1 (c1) VALUES(11); 126INSERT IGNORE INTO t1 (c1) VALUES(10); 127Warnings: 128Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 129SELECT * FROM t1; 130c1 13110 13211 133DROP TABLE t1; 134CREATE TABLE t1(c1 DOUBLE PRECISION NOT NULL PRIMARY KEY); 135INSERT INTO t1 (c1) VALUES(10); 136INSERT INTO t1 (c1) VALUES(11); 137INSERT IGNORE INTO t1 (c1) VALUES(10); 138Warnings: 139Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 140SELECT * FROM t1; 141c1 14210 14311 144DROP TABLE t1; 145CREATE TABLE t1(c1 FLOAT NOT NULL PRIMARY KEY); 146INSERT INTO t1 (c1) VALUES(10); 147INSERT INTO t1 (c1) VALUES(11); 148INSERT IGNORE INTO t1 (c1) VALUES(10); 149Warnings: 150Warning 1062 Duplicate entry '10' for key 't1.PRIMARY' 151SELECT * FROM t1; 152c1 15310 15411 155DROP TABLE t1; 156