PHQL not support ORDER BY term in DELETE ?

Question

PHQL not support ORDER BY term in DELETE ?

陈永旺 Apr '14

Created Apr '14	Last Reply Apr '14	Replies 2	Views 545	Votes 0

陈永旺 4.3k

Apr '14

I use PHQL in my project, I got an error.Here is my code:


<?php

$query = 'DELETE FROM Cars WHERE price < 50000 ORDER BY id ASC LIMIT 100';
$modelsManager->executeQuery($query);

It does not work in Phalcon V1.2.6 in windows.But I test the native SQL statement in phpmyadmin,it works.why?

Thien Tran · Answer 1 · 2014-04-16T20:15:34-07:00

Hi I don't think it necessary when use SQL delete above

$query = 'DELETE FROM Cars WHERE price < 50000 ';

陈永旺 · Answer 2 · 2014-04-16T20:51:55-07:00

陈永旺
4.3k

Apr '14

how do you delete the last 100 records in database.

Dylan Anderson · Answer 3 · 2014-04-17T10:36:35-07:00

The latest Phalcon version is 1.3.1 - you should update to that and try again. I don't know for sure if it will fix the problem, but 1.3.0 had TONS of updates, and it's always best to try the latest version of software when you have problems like this.

If you do all that' and it still doesn't work, then I'd ask what "doesn't work" actually means? Does the query not get sent to your DB? Does Phalcon throw an exception? Do all "Cars" get deleted? Do no "Cars" get deleted?