---

mysql> delimiter //
mysql> create procedure delete_order_item_by_item (in p_item_id int)
    -> begin
    -> declare cnt int;
    -> select count(*) into cnt from order_items where items.id = p_item_id;
    -> if cnt > 0 then
    -> delete from order_items
    -> where items_id = p_item_id
    -> select 'Все позиции заказа для данного товара удалены' as message;
    -> else
    -> select 'Товар в позициях заказа не найден' as message;
    -> end if;
    -> end //
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select 'Все позиции заказа для данного товара у' at line 8
mysql>