简单点就建三个表,一个表存大类,有DA_ID和DA_NAME,一个表存小类还有大类相关ID,有三个字段:DA_ID、XIAO_ID和XIAO_NAME,一个表存文章还有小类ID,起码三个字段,XIAO_ID、WEN_ID和WEN_NAME
删除时,先删文章表,再删小类表,再删大类表
delete from WEN w,XIAO x,DA d where d.DA_ID=x.DA_ID and x.XIAO_ID=w.XIAO_ID and d.DA_ID='要删的大类ID'
delete from XIAO x,DA d where d.DA_ID=x.DA_ID and d.DA_ID='要删的大类ID'
delete from DA where DA_ID='要删的大类ID'
如果能写个存储过程就更好了,传一个参数就搞定了