So, you are want to delete entries by using a subquery and the limit and all you get back is something like the following:
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
The solution is a little bit tricky and costs a bit performance but it is working, try the following:
DELETE FROM `my_table`
WHERE `my_table`.`id` IN (
SELECT * FROM (
SELECT `my_other_table`.`id`
FROM `my_other_table`
WHERE `my_other_table`.`condition` = 'My condition'
LIMIT 0, 100
)
as deleteTable);
I really and a long time thought about a problem with a cronjob php skript. This script has to run long (in php terms, very long or lets say longer than one hour). I implemented a lot of verbose output and figured out that the script is using more and more memory. Thats why i implemented the using of "gc_enable()" and "gc_collect_cycles" without less luck. After a while i tackeld it down to my favorit used php orm mapper called propel. After having "propel" in my mind, the instance pooling comes in my mind and the final fix was reachable.
\Propel::disableInstancePooling();
Add the code on top to your script and the memoryusage should not increase anymore (or you have another memory hole ;-)).
Der Fehler war, dass "9" nach "1,13,14" sortiert wurde. Zurecht wurde dies als Fehler angesehen, jedoch war mein JavaScript-Wissen bis zu diesem Zeitpunkt nicht mit obrigen Zitat angereichert. Dadurch suchte man, zweifelte an seinem RegExpr und schrieb viele "console.log()" in den fremden Quelltext.
Nach einer gewissen Zeit, kam auch der Rückgabewert an die Reihe. Als man Diesen dann im Log sah, zweifelte man kurz an allem. Zum Glück fand ich schnell, den oben verlinkten, Seiteneintrag und konnte die nötigen Anpassungen vornehmen :-).
Weitere Links zum Thema "JavaSkript" und "Sortierung":
I just found a store based in south korea who is selling android development platforms. The store is called hardkernel.
It is selling a Exynos4412 ARM Cortex-A9 Quad Core with hdmi output but only a shared 100 MBit nic.
A "little bit" over "ultra low cost" but maybe worth a look.
* Low-cost mobile software development platform
- Quad core ARM Cortex-A9 MPCore
- 6 x High speed USB2.0 Host port
- 10/100Mbps Ethernet with RJ-45 LAN Jack
- Audio codec with headphone jack and microphone jack
- Android 4.0.4 ICS
- Community-driven projects & supports