SDSHOWTO:HowTo...Delete Statments

From SMUSwiki
Revision as of 13:21, 7 February 2024 by Jay.prost (talk | contribs) (Created page with "Connect to mysql for the Version you are working on Run the following lines in order replacing ? with the statement item * DELETE statement_line_item.* FROM statement_line_item INNER JOIN rel_person_statement ON rel_person_statement.rel_person_statement_id = statement_line_item.rel_person_statement_id WHERE rel_person_statement.statement_id=265; * DELETE FROM rel_person_statement WHERE statement_id=269; * DELETE FROM statement WHERE statement_id=269;")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Connect to mysql for the Version you are working on Run the following lines in order replacing ? with the statement item

  • DELETE statement_line_item.* FROM statement_line_item INNER JOIN rel_person_statement ON rel_person_statement.rel_person_statement_id = statement_line_item.rel_person_statement_id WHERE rel_person_statement.statement_id=265;
  • DELETE FROM rel_person_statement WHERE statement_id=269;
  • DELETE FROM statement WHERE statement_id=269;