mysql workbench 掘金,【mybatis】mybatis动态order by 的问题， 注意 只需要把#{} 改成 ${} 即可...

select

a.id as 'id',

a.uid as 'uid',

a.create_date as 'createDate',

a.update_date as 'updateDate',

a.update_id as 'updateId',

a.create_id as 'createId',

a.brand_uid as 'brandUid',

a.tid as 'tid',

a.stock as 'stock',

a.name as 'name',

a.goods_code as 'goodsCode',

a.market_value as 'marketValue',

a.specification as 'specification',

a.remark as 'remark',

a.type as 'type',

a.integral as 'integral',

a.description as 'description',

a.sale_num as 'saleNum',

a.limit_num as 'limitNum',

a.shelf_flag as 'shelfFlag',

a.home_show_flag as 'homeShowFlag',

sl.shelf_date as 'shelfDate',

sl.obtained_date as 'obtainedDate',

b.id b_id,

b.src b_src,

b.type b_type,

b.sort b_sort

from

integral_goods a

left join

integral_goods_img b

on

a.uid = b.integral_goods_id

left join

shelf_log sl

on

a.uid = sl.integral_goods_uida.uid

IN#{item}

order by #{order} #{orderType}