Удаление неиспользуемых производителей
04 апр.


Заметка: удаление неиспользуемых производителей из базы данных опенкарт
DELETE manufacturer, manufacturer_description, manufacturer_to_store FROM manufacturer LEFT JOIN manufacturer_description ON manufacturer_description.manufacturer_id = manufacturer.manufacturer_id LEFT JOIN manufacturer_to_store ON manufacturer_to_store.manufacturer_id = manufacturer.manufacturer_id WHERE manufacturer.manufacturer_id NOT IN (SELECT DISTINCT manufacturer_id FROM product)
Оставить комментарий