Comments on: Three wishes for a new year https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year Blog by Shlomi Noach Fri, 02 Dec 2011 11:45:19 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: MySQL foreach() | code.openark.org https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year/comment-page-1#comment-61308 Fri, 02 Dec 2011 11:45:19 +0000 https://shlomi-noach.github.io/blog/?p=2937#comment-61308 […] does not support ORDER BY & LIMIT in multi-table UPDATE and DELETE statements (as noted last year). So we […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year/comment-page-1#comment-17450 Fri, 10 Sep 2010 04:21:21 +0000 https://shlomi-noach.github.io/blog/?p=2937#comment-17450 @Justin,
As another note: there is a problem with applying your solution, which does not (and cannot) use ORDER BY, since queries become replication-unsafe.
Actually, it may not bee such a problem if you want to do complete query is smaller chunks, in which case the ORDER does not really matter, replication-wise. But I can still see it leading to issues if new rows are added which match the DELETE/UPDATE WHERE condition.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year/comment-page-1#comment-17449 Fri, 10 Sep 2010 04:07:51 +0000 https://shlomi-noach.github.io/blog/?p=2937#comment-17449 @Justin: thanks for the reference!

]]> By: Yaron https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year/comment-page-1#comment-17434 Thu, 09 Sep 2010 20:04:27 +0000 https://shlomi-noach.github.io/blog/?p=2937#comment-17434 Amen to that! 🙂

]]> By: Justin Swanhart https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year/comment-page-1#comment-17431 Thu, 09 Sep 2010 18:52:58 +0000 https://shlomi-noach.github.io/blog/?p=2937#comment-17431 Oh, I forgot that I blogged about that before:
http://swanhart.livejournal.com/120806.html

]]> By: Justin Swanhart https://shlomi-noach.github.io/blog/mysql/three-wishes-for-a-new-year/comment-page-1#comment-17430 Thu, 09 Sep 2010 18:49:49 +0000 https://shlomi-noach.github.io/blog/?p=2937#comment-17430 I have a user-variable abusing method for Multi-table delete + LIMIT. I think I’ve only tested it for deleting from one table, but where that table needs to be joined to other tables.

]]>