Hotfirenet/prestashop_delete_carte.sql

Created February 14, 2017 08:50

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Hotfirenet/8933061a89f235415f577a7214462eef.js"></script>
Save Hotfirenet/8933061a89f235415f577a7214462eef to your computer and use it in GitHub Desktop.

Download ZIP

Requete SQL pour prestashop qui permet de supprimer tous les paniers d'un client.

Raw

prestashop_delete_carte.sql

	SET @idCustomer = 13377;

	DELETE CP, P
	FROM ps_cart_product CP
	INNER JOIN ps_cart C ON C.id_cart = CP.id_cart
	WHERE C.id_customer = @idCustomer

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment