如何用SQL语句清空呆错网址导航系统的所有数据?

2022-06-03 23:02:31 使用文档

SQLITE3代码如下,包含清空栏目分类、标签数据、内容数据,并且将ID归零

DELETE FROM dc_term;
DELETE FROM dc_term_meta;
DELETE FROM dc_term_map;
DELETE FROM dc_term_meta;
DELETE FROM dc_info;
DELETE FROM dc_info_meta;
DELETE FROM sqlite_sequence WHERE name='dc_term';
DELETE FROM sqlite_sequence WHERE name='dc_term_meta';
DELETE FROM sqlite_sequence WHERE name='dc_term_map';
DELETE FROM sqlite_sequence WHERE name='dc_term_meta';
DELETE FROM sqlite_sequence WHERE name='dc_info';
DELETE FROM sqlite_sequence WHERE name='dc_info_meta';

clear-data.png

MYSQL代码如下,包含清空栏目分类、标签数据、内容数据,并且将ID归零

truncate table dc_term;
truncate table dc_term_meta;
truncate table dc_term_map;
truncate table dc_term_meta;
truncate table dc_info;
truncate table dc_info_meta;

15

作者:admin

链接:https://demo.daicuo.org/cmsdetail/660

来源:呆错后台管理框架

著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。

上一篇:呆错网址导航系统搬家方法、网站迁移方法

下一篇:呆错后台管理框架JS组件-对话框