Question

hibernate中sql原生查询中大括号是什么作用

Answer 1

select MAX(CAST(x.serial as SIGNED))+1 as number from (select SUBSTRING(GOODS_ID,LOCATE('005001007',GOODS_ID)+LENGTH('005001007')) as serial from BUS_GOODS where ID like '%005001007%') x where x.serial <> ''

你确定这句话在mysql里能跑？里面有两个where啊，而且第二个where前面还有个x是要闹哪样？