第 1 頁 (共 1 頁)
truncate
發表於 : 2018-06-04 10:57:56
由 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
Re: truncate
發表於 : 2019-07-11 18:42:19
由 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';