SQLite Forum

Problem with Sqlite DELETE documentation
Login
Incorrect.

This clause is extremely important.  It means that a statement like:

DELETE FROM t0 ORDER BY something;  
is processed exactly the same as  
DELETE FROM t0;  

and that the "ORDER BY" is irrelevant to the order of deletion.  If it had no meaning then it would not be included.

In other words, stating that "the colour that the gun is painted has no effect on the range or velocity of the projectile" means precisely and exactly what it says:  that a pink gun is no more accurate and discharges bullets at the same velocity as a gun painted lavender despite any "wishing" to the contrary.  It says nothing however as to whether the pink or the lavender gun may go better with your ensemble.  Or whether the components of the pink paint are heavier than the components of the lavender paint.