why mysql do not allow alias for tables in delete from clause
Posted by:
vasil
Date: November 16, 2006 05:49AM
Why mysql do not allow alias for tables in delete from clause.
I am using MySQL 5.0.18-standard and the following statement gives an error:
delete form table1 t
where t.somefiled = 1;
I want to use table alias for more complicated where clause than the one in the example (it does includes the table I am deleting from and beleave me there is no other way to do it without alias). But I can not because it is not supported. Why something so simple is not supported?!
Subject
Written By
Posted
why mysql do not allow alias for tables in delete from clause
November 16, 2006 05:49AM
November 16, 2006 08:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.