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]

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';