主题 : 删除栏目之后,是不是栏目内容也同时都被删除掉了 |
级别: 商业授权用户
|
1# 发表于:2023-05-12 10:39:19 IP:101.166.*.*
|
||||
---|---|---|---|---|---|
级别: 商业授权用户
|
3# 发表于:2023-05-12 11:39:14 IP:101.166.*.*
回复第2楼
那么怎么从数据库彻底删掉呢 要删除哪些表的信息呀 |
||
---|---|---|---|
级别: 总版主
|
4# 发表于:2023-05-12 11:52:35 IP:115.210.*.*
是要清空所有内容吗?下面的是清空所有内容 delete from jc_content; delete from jc_content_annotation; delete from jc_content_attr; delete from jc_content_attr_res; delete from jc_content_channel; delete from jc_content_check; delete from jc_content_check_detail; delete from jc_content_check_error; delete from jc_content_ext; delete from jc_content_like_record; delete from jc_content_mark; delete from jc_content_publish_record; delete from jc_content_record; delete from jc_content_relation; delete from jc_content_source; delete from jc_content_txt; delete from jc_content_version; delete from jc_statistics_content_data; delete from jc_tr_content_tag; delete from jc_tr_content_type; delete from jc_tr_copy_content; delete from jc_tr_user_content_like; delete from jc_tr_user_comment_like; delete from jc_user_comment; delete from jc_user_comment_report; |
||
---|---|---|---|
级别: 商业授权用户
|
5# 发表于:2023-05-12 14:14:11 IP:101.166.*.*
回复第4楼
谢谢您,想要从数据库里删掉,某一个的栏目 的栏目内容; |
||
---|---|---|---|
级别: 总版主
|
6# 发表于:2023-05-12 14:18:09 IP:115.210.*.*
delete from jc_content where where channel_id =1000;
这下面的表加where 内容id字段不在jc_content表就行 delete from jc_content_annotation ; delete from jc_content_attr; delete from jc_content_attr_res; delete from jc_content_channel; delete from jc_content_check; delete from jc_content_check_detail; delete from jc_content_check_error; delete from jc_content_ext; delete from jc_content_like_record; delete from jc_content_publish_record; delete from jc_content_record; delete from jc_content_relation; delete from jc_content_source; delete from jc_content_txt; |
||
---|---|---|---|
级别: 商业授权用户
|
7# 发表于:2023-05-12 16:46:58 IP:101.166.*.*
delete from jc_content where where channel_id =1000;这个是删主表
delect from jc_content_annotation where content_id not in (select channel_id form jc_connect )这个是删除子表里 对应被删除栏目,的关联关系吗? (select channel_id form jc_connect )这里是 channel_id字段对吗 |
||
---|---|---|---|
级别: 总版主
|
8# 发表于:2023-05-12 18:13:19 IP:115.210.*.*
delect from jc_content_annotation where content_id not in (select channel_id form jc_connect )
应该都有内容id |
||
---|---|---|---|
1
共1页