in reply to (OT) MySQL: delete from multiple tables

Hi

For deleting multiple tables you need to use like this.

DELETE table1.*, table2.*,table3.* FROM table1, table2, table3 WHERE table1.data_id="111";

-perl_lover
  • Comment on Re: (OT) MySQL: delete from multiple tables