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