创建视图 CREATE VIEW testrole AS SELECT a.description,a.id,a.role_key from role a LEFT JOIN role_authority b on a.role_key = b.role_key SELECT *FROM testrole; 查询所有视图 show table status where comment='view'; 删除视图 drop VIEW testrole 注意:操作视图是会影响到基表