创建一个表
CREATE TABLE tb_student( id INT PRIMARY KEY AUTO_INCREMENT, sname VARCHAR(20), age INT, sex VARCHAR(10) );
向表中插入3条记录
INSERT INTO tb_student(sname, age, sex) VALUES('a',12,'男'),('b',14,'男'),('c',18,'男') #delete 删除数据，保留表结构 #删除指定行 DELETE FROM tb_student WHERE id=1 #删除所有行 DELETE FROM tb_student #删除指定区间的行 DELETE FROM tb_student WHERE id BETWEEN 1 AND 3 # truncate 删除表所有数据，保留结构 TRUNCATE TABLE tb_student
# drop 删除数据和表结构 DROP TABLE tb_student
