Добрый день!
Есть строка запроса.....
Запрос =
DELETE FROM ps_cart WHERE ps_cart.id_cart = ИД
DELETE FROM ps_cart_product WHERE ps_cart_product.id_cart = ИД
DELETE FROM ps_orders WHERE ps_ps_orders.id_order = ИД1
DELETE FROM ps_order_history WHERE ps_order_history.id_order = ИД1
DELETE FROM ps_order_detail WHERE ps_order_detail.id_order = ИД1;
Вопрос такой..
В данном примере каждая таблица очищается отдельно, то-есть отдельной операцией.
Вопрос Пройдет ли такой вариант одним запросом типа
Запрос="
DELETE FROM ps_cart,ps_cart_product,ps_orders,ps_order_history,ps_order_detail
WHERE ps_cart.id_cart = ИД AND ps_cart_product.id_cart = ИД AND ps_ps_orders.id_order = ИД1 AND ps_order_history.id_order = ИД1 AND ps_order_detail.id_order = ИД1
"
Спасибо!