MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: convert slq server query
Posted by: Peter Brawley
Date: January 06, 2022 10:10AM

In MySQL you "cannot delete from a table and select from the same table in a subquery". I think DISTINCT was raise issues too. See https://dev.mysql.com/doc/refman/8.0/en/delete.html for MySQL multi-delete syntax.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
convert slq server query
Paulo Betim
January 06, 2022 08:46AM
Re: convert slq server query
Peter Brawley
January 06, 2022 10:10AM


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.