MySQL Forums
Forum List  »  Newbie

Re: Newbe needs help!
Posted by: Peter Brawley
Date: June 23, 2022 10:46AM

The query requirement looks incomplete. Try writing it in such a detailed manner that a 12-year-old could use it to manually and correctly pick out the rows it specifies.

Write that as a query which selects the primary keu values of those rows

Check the result row by row to ensure that it captures the requirement perfectly.

You propose to delete rows; make a backup of the table.

Wrote an outer query that deletes rows identified by the above query eg ...

delete *
from practice.listing_analysis
where <name_of_pk_column > in (<above query>)

If you get stuck, post the result of ...

show create table practice.listing_analysis;

... together with the complete requirement and your query so far.

Options: ReplyQuote

Written By
June 23, 2022 03:11AM
Re: Newbe needs help!
June 23, 2022 10:46AM

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.