Užitečné sql

Promazání menuitemů

SELECT  @id := id FROM menu_item WHERE id IN (9);

DELETE FROM menu_item_x_file WHERE menu_item_id = @id;
DELETE FROM menu_item_x_gallery WHERE menu_item_id = @id;
DELETE FROM menu_item_x_menu_item WHERE menu_item_id = @id;
DELETE FROM menu_item_x_product WHERE menu_item_id = @id;
DELETE FROM menu_item_x_supplement WHERE menu_item_id = @id;
DELETE FROM menu_item WHERE id menu_item_id = @id;