6.4 数据库连接池***删除表中数据***

 导入Druid 1.1.12jar包

删除表中所有数据：

truncate table + 表名

SET FOREIGN_KEY_CHECKS=0 //解除主外键约束

TRUNCATE TABLE exercise;    //删除数据
SET FOREIGN_KEY_CHECKS=1  //恢复主外键约束

**写完查询代码

常用sql代码：

INSERT INTO exercise(extype,chapter,c_num,content)
VALUES('填空','1','1','1+1=？'),('选择','2','2','这题选啥')
INSERT INTO exercise(extype,chapter,c_num,content)
VALUES('提问','1','1','2+2=？')
INSERT INTO cource(cnum,cname)
VALUES('1','计算机'),('2','艺术')
SELECT * FROM exercise;
DELETE FROM exercise;
TRUNCATE TABLE exercise;
SELECT * FROM cource;
SET FOREIGN_KEY_CHECKS=0
SET FOREIGN_KEY_CHECKS=1
UPDATE exercise SET extype=?,chapter=?,c_num=?,content=? WHERE id=?
DELETE FROM exercise WHERE id=?