1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 TEXT); 3SHOW CREATE TABLE t1; 4Table Create Table 5t1 CREATE TABLE `t1` ( 6 `c1` int NOT NULL, 7 `c2` text, 8 PRIMARY KEY (`c1`) 9) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 10SHOW TABLES; 11Tables_in_test 12t1 13ERROR 23000: Duplicate entry '1' for key 't1.PRIMARY' 14TRUNCATE TABLE t1; 15Warnings: 16Warning 1062 Duplicate entry '1' for key 't1.PRIMARY' 17Warning 1062 Duplicate entry '1' for key 't1.PRIMARY' 18Warning 1062 Duplicate entry '0' for key 't1.PRIMARY' 19SELECT * FROM t1 ORDER BY c1; 20c1 c2 210 def 221 abc 23TRUNCATE TABLE t1; 24SELECT * FROM t1 ORDER BY c1; 25c1 c2 260 opq 271 jkl 28DROP TABLE t1; 29