maxout/delete duplicate order numbers.sql

Last active March 1, 2022 08:06

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

Select an option

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

Download ZIP

delete duplicate order numbers from shopware s_order

Raw

delete duplicate order numbers.sql

DELETE FROM s_order USING s_order, s_order as Dup WHERE NOT s_order.`id` = Dup.`id` AND s_order.`id` <> Dup.`id` AND s_order.`ordernumber` = Dup.`ordernumber`

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