in reply to (OT) MySQL: delete from multiple tables
Starting in MySQL 4.1 you can use table aliases (must be consistent in both the FROM and USING clausesDELETE FROM table1, table2, table3 USING table1 INNER JOIN table2 USING(data_id) INNER JOIN table3 USING(data_id) WHERE table1.data_id = 111
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: (OT) MySQL: delete from multiple tables
by Anonymous Monk on May 28, 2013 at 08:29 UTC |