I'm not sure if I'm using this delete statment or not. I have 7 tables set up where each row has a unique ID number, which matches up with rows in other tables. What I want to do is delete all of those row from all the tables that match the unique ID number.
Here's the statement I tried:
Here's the error I got:
DELETE FROM maintable, storage, arrangement, format, textareas, record_retention, record_status WHERE maintable.UID=3 AND storage.UID_ref=3 AND arrangement.UID_ref=3 AND format.UID_ref=3 AND textareas.UID_ref=3 AND record_retention.UID_ref=3 AND record_status.UID_ref=3
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE maintable.UID=3 AND storage.UID_ref=3 AND arrangement.UID_ref=3 AND format' at line 1