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'

  

posted @ 2019-02-02 23:47  hoge  阅读(853)  评论(0)    收藏  举报