Git Patch generator
Noeud final
Filtre sur le noeud final
Avec nème noeuds qui précéde ~n
Avec il y a n jours
Noeud de fin non inclus dans le patch
Get Code
Migration Tool
Source Host
Source User
Source Password
Source Name
Dest Host
Dest User
Dest Password
Dest Name
Get Linux Code
SQL Table Replace
Table
Field
To Search
Replace By
Get Replace Code
PrestaShop Password Replace
Email Account
Password
Get Code
Suppression de commande
DELETE FROM `ps_address` WHERE id_customer not in (0, 13, 21,24,26); DELETE FROM `ps_customer` WHERE id_customer not in (0, 13, 21,24,26); DELETE FROM `ps_orders` WHERE id_order not in (27,46,47,48); DELETE FROM `ps_order_carrier` WHERE id_order not in(SELECT id_order FROM `ps_orders`); DELETE FROM `ps_order_detail` WHERE id_order not in(SELECT id_order FROM `ps_orders`); DELETE FROM `ps_order_detail_tax` WHERE id_order_detail not in(SELECT id_order_detail FROM `ps_order_detail`); DELETE FROM `ps_order_history` WHERE id_order not in(SELECT id_order FROM `ps_orders`); DELETE FROM `ps_order_invoice` WHERE id_order not in(SELECT id_order FROM `ps_orders`); DELETE FROM `ps_order_invoice_payment` WHERE id_order_invoice not in(SELECT id_order_invoice FROM `ps_order_invoice`); DELETE FROM `ps_order_invoice_tax` WHERE id_order_invoice not in(SELECT id_order_invoice FROM `ps_order_invoice`); DELETE FROM `ps_order_payment` WHERE order_reference not in(SELECT reference FROM `ps_orders`); DELETE FROM `ps_cart` WHERE id_cart not in (102,118,126,73); DELETE FROM `ps_cart_cart_rule` ; DELETE FROM `ps_cart_product` WHERE id_cart not in(SELECT id_cart FROM `ps_cart`); DELETE FROM `ps_cart_rule` ; DELETE FROM `ps_guest` ;
Get Code
×