问题描述:清空角色权限中间表时,提示如下错误新增:Can't DROP 'FKf8yllw1ecvwqy3ehyxawqa1qp'; check that column/key exists
解决办法:
查询role_permission表,正在使用的外键:
show keys from role_permission;
删除role_permission 表中的FKf8yllw1ecvwqy3ehyxawqa1qp 外键
alter table role_permission drop index FKf8yllw1ecvwqy3ehyxawqa1qp;