Užitečné sql

Promazání menuitemů

SET @id := '5';

DELETE T1, T2, T3, T4, T5
FROM menu_item TM
LEFT JOIN menu_item_x_file T1  ON T1.menu_item_id = TM.id 
LEFT JOIN menu_item_x_gallery T2 ON T2.menu_item_id = TM.id 
LEFT JOIN menu_item_x_menu_item T3 ON T3.menu_item_id = TM.id 
LEFT JOIN menu_item_x_product T4 ON T4.menu_item_id = TM.id 
LEFT JOIN menu_item_x_supplement T5 ON T5.menu_item_id = TM.id 
WHERE TM.id > @id;

DELETE TM
FROM menu_item_x_menu_item TM
WHERE TM.id > @id;

DELETE TM
FROM menu_item TM
WHERE TM.id > @id;