MySQL Forums
Forum List  »  General

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.

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.