table1 中的uid、table2 中的projectkey、table3 中的projectkey相关联(table1.uid=table2.projectkey=table3.projectkey)当删除table1该条数据时,同时删除table2和table3对应的数据。table1一定有数据,table2和table3不一定有数据
DELETE table1, table2, table3 FROM table1 LEFT JOIN table2 ON table1.uid = table2.projectkey LEFT JOIN table3 ON table1.uid = table3.projectkey WHERE table1.uid = '值'