inventory = /path/to/inventory inventory = /path/to/inventory
可将其更改为:
inventory = /path/to/inventory
SELECT id, name, organization_id, type, inventory_source_id, inventory_update_id FROM main_inventory WHERE inventory_update_id IS NOT NULL ORDER BY inventory_update_id DESC;
DELETE FROM main_inventory WHERE id NOT IN ( SELECT MAX(id) AS max_id FROM main_inventory GROUP BY name, organization_id, type, inventory_source_id, inventory_update_id );