简单的操作

select user_id from ls_usr_detail where ls_usr_detail.user_mobile = '13178820975' into @userID
select @userID
delete  from ls_usr_detail where user_id = (select @userID);


delete from ls_usr_role where user_id = (select @userID);

delete from ls_user where id = (select @userID);

delete from ls_passport where user_id =  (select @userID);

   请尊重知识，请尊重原创 更多资料参考请见  http://www.cezuwang.com/listFilm?page=1&areaId=906&filmTypeId=1