如何删除或清空网站的所有订单,顾客,和商品?

[wong]

代码: 全选

TRUNCATE TABLE `address_book`;
TRUNCATE TABLE `admin_activity_log`;
TRUNCATE TABLE `counter`;
TRUNCATE TABLE `counter_history`;
TRUNCATE TABLE `customers`;
TRUNCATE TABLE `customers_basket`;
TRUNCATE TABLE `customers_info`;
TRUNCATE TABLE `orders`;
TRUNCATE TABLE `orders_products`;
TRUNCATE TABLE `orders_status_history`;
TRUNCATE TABLE `orders_total`;
TRUNCATE TABLE `paypal`;
TRUNCATE TABLE `paypal_payment_status_history`;
TRUNCATE TABLE `paypal_session`;
update `products_description` set `products_viewed` = '0' WHERE `products_viewed` > '0';
update `products` set `products_ordered` = '0' WHERE `products_ordered` > '0';

清除一些数据！今天自己操作了下...还好把SQL保存着

[iforeb]

还没试过，不过还是谢谢jack的方法^_^

[wei3692]

看到

[youshangtao]

请教一下 大家不小心把后太产品属性的选项给删除了（下拉列表等属性）
我改怎么恢复呢？ 喔没有备份数据库
谢谢大家

[Jack]

后台的工具－安装SQL脚本下执行：

代码: 全选

INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (0, '下拉');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (1, '文本');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (2, '单选');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (3, '多选');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (4, '文件');
INSERT INTO products_options_types (products_options_types_id, products_options_types_name) VALUES (5, '只读');