truncate

https://invdemo.551.com.tw
回覆文章
yehlu
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

truncate

文章 yehlu »

代碼: 選擇全部

truncate admin_operation_log;
truncate bitimages;
truncate branchs;
truncate customers;
truncate inv_bodies;
truncate inv_heads;
truncate inv_logs;
truncate inv_numbers;
truncate invb_bodies;
truncate invb_heads;
truncate products;
truncate supplys
yehlu
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

Re: truncate

文章 yehlu »

DELETE FROM admin_operation_log;
DELETE FROM customers;
DELETE FROM inv_bodies;
DELETE FROM inv_heads;
DELETE FROM inv_logs;
DELETE FROM inv_numbers;
DELETE FROM invb_bodies;
DELETE FROM invb_heads;
DELETE FROM products;
DELETE FROM ord_bodies;
DELETE FROM ord_heads;
DELETE FROM admin_menu where id > 41;

DELETE FROM sqlite_sequence WHERE name = 'admin_operation_log';
DELETE FROM sqlite_sequence WHERE name = 'customers';
DELETE FROM sqlite_sequence WHERE name = 'inv_bodies';
DELETE FROM sqlite_sequence WHERE name = 'inv_heads';
DELETE FROM sqlite_sequence WHERE name = 'inv_logs';
DELETE FROM sqlite_sequence WHERE name = 'inv_numbers';
DELETE FROM sqlite_sequence WHERE name = 'invb_bodies';
DELETE FROM sqlite_sequence WHERE name = 'invb_heads';
DELETE FROM sqlite_sequence WHERE name = 'products';
DELETE FROM sqlite_sequence WHERE name = 'ord_bodies';
DELETE FROM sqlite_sequence WHERE name = 'ord_heads';
update sqlite_sequence set seq=41 WHERE name = 'admin_menu';
回覆文章

回到「551einv」