SDSHOWTO:HowTo...Delete Statments: Difference between revisions
Jump to navigation
Jump to search
(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;") |
No edit summary |
||
| Line 2: | Line 2: | ||
Run the following lines in order replacing ? with the statement item | 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= | * 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=?; | ||
* DELETE FROM rel_person_statement WHERE statement_id= | * DELETE FROM rel_person_statement WHERE statement_id=?; | ||
* DELETE FROM statement WHERE statement_id= | * DELETE FROM statement WHERE statement_id=?; | ||
Latest revision as of 06:32, 9 February 2024
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=?;
- DELETE FROM rel_person_statement WHERE statement_id=?;
- DELETE FROM statement WHERE statement_id=?;