1、执行下面语句时，报错Every derived table must have its own alias
select * from (select * from jt_notes where createUser = 'b548323007b647809bb8e4192cf44195' limit 0,10)
2、解决方案，加一个别名就可以了
select * from (select * from jt_notes where createUser = 'b548323007b647809bb8e4192cf44195' limit 0,10) user
标签：own,derived,alias,Every,table,its,select From： https://www.cnblogs.com/wwssgg/p/17683426.html