Mysql multi table delete effect all but one table -
Mysql multi table delete effect all but one table -
i used next sql syntax delete several tables. result info erased table 2-4 not in table 1 (no errors)
delete table1, table2, table3, table4 table2 bring together table1 on table1.id = table2.deviceid bring together table3 on table3.deviceid = table2.deviceid bring together table4 on table4.device_id = table2.deviceid table2.deviceid = 1;
what doing wrong?
mysql
Comments
Post a Comment