考虑三个表-演员、角色和电影 mysql> DESCRIBE actors;+-----------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec) 下面的查询列出了电影> (SELECT id FROM movies WHERE name='Schindler\'s Lis
问题描述;select * from login.user u join user_role ur on u.id = ur.user_idu join user_role ur on u.id = ur.user_id join role r on ur.role_id = r.id where r.name in (:rol