MySQL TRUNCATE:删除表记录
例 1新建表 tb_student_course,插入数据并查询,SQL 语句和运行结果如下:mysql CREATE TABLE `tb_student_course` (- `id` int(4) NOT NULL AUTO_INCREMENT,- `name` varchar(25) NOT NULL,- PRIMARY KEY (`id`)- );Query OK, 0 rows affected (0.04 sec)
例 1新建表 tb_student_course,插入数据并查询,SQL 语句和运行结果如下:mysql CREATE TABLE `tb_student_course` (- `id` int(4) NOT NULL AUTO_INCREMENT,- `name` varchar(25) NOT NULL,- PRIMARY KEY (`id`)- );Query OK, 0 rows affected (0.04 sec)