select sum(level_exp) from experience where id in(select id from experience order by level asc limit 5 )
原因是在in中不支持limit函数,修改办法
select sum(level_exp) from(select level_exp from experience order by level asc limit 5 ) as data
将数据转换成表
select sum(level_exp) from experience where id in(select id from experience order by level asc limit 5 )
原因是在in中不支持limit函数,修改办法
select sum(level_exp) from(select level_exp from experience order by level asc limit 5 ) as data
将数据转换成表