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

Popular posts from this blog

Delphi change the assembly code of a running process -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

C++ 11 "class" keyword -