Can MySQL 5.0 peform multiple-table inserts, updates, and deletes?
Yes. For the syntax required to perform multiple-table updates, see Section 12.2.10, “UPDATE Syntax”; for that required to perform multiple-table deletes, see Section 12.2.1, “DELETE Syntax”. A multiple-table insert can be accomplished using a trigger whose FOR EACH ROW clause contains multiple INSERT statements within a BEGIN … END block. See Section 20.3, “Using Triggers”.