| Multi-Table Deletes |
|
|
|
|
|
| • | Think
of it a delete on a join… |
|||
| • | You
can also use ORDER
BY |
|||
| • | And LIMIT |
|||
|
|
|
|
|
| DELETE t1,t2 FROM t1,t2,t3 |
||||
| WHERE t1.id=t2.id AND t2.id=t3.id |
||||
| DELETE FROM mytable |
||||
| WHERE user = ‘foo‘ |
||||
| ORDER BY timestamp |
||||
| LIMIT
10 |
||||
