mysql 删除用户

select * FROM sys_user_role where user_id in(
SELECT id FROM sys_user where login_name='17600311226'
)

delete FROM sys_user_role where user_id in(
SELECT id FROM sys_user where login_name='17600311226'
)

delete FROM sys_user where login_name='17600311226'

  

www.beicaiduo.com
原文地址:https://www.cnblogs.com/hoge66/p/10349477.html