mysql的关联删除:
delete user_tbl,role_tbl,permission_tbl,user_role_tbl,role_permission_tbl
from user_tbl
LEFT JOIN role_tbl
on user_tbl.id = role_tbl.MERCHANT_ID
LEFT JOIN permission_tbl
on user_tbl.id = permission_tbl.merchantId
LEFT JOIN user_role_tbl
on user_tbl.id = user_role_tbl.merchant_id
LEFT JOIN role_permission_tbl
on user_tbl.id = role_permission_tbl.MERCHANT_ID
where (user_tbl.id = '3b13d3e1-ac37-11e4-9c5a-40167e360f63' or user_tbl.id = 'd51fa88c-fa9f-11e4-9fe2-c81f66de5122')
1·以上表名只是单纯的显示不代表任何逻辑在内
2·表名不要使用后缀名