小弟我初学者又问有关问题了，这句代码如何改啊如何没有order by就对了呢

我菜鸟又问问题了，这句代码怎么改啊，怎么没有order by就对了呢

update BUS_PROD_ITEM_SN b set b.ACTION_BY = (select t.ACTION_BY from BUS_PROD_SN_LOG t limit 0,1 order by t.PRODUCT_ITEM_SN_IDX desc);

在mysql里的啊！

update BUS_PROD_ITEM_SN b set b.ACTION_BY = (select t.ACTION_BY from BUS_PROD_SN_LOG t order by t.PRODUCT_ITEM_SN_IDX desc limit 0,1);




order by 在 limit 之前。

update BUS_PROD_ITEM_SN b set b.ACTION_BY = (

select t.ACTION_BY from BUS_PROD_SN_LOG t order by t.PRODUCT_ITEM_SN_IDX desc limit 0,1 );




记住 limit 是放在最后的




对滴。。要先order by 再limit




3楼正解




探讨

order by 在 limit 之前。

update BUS_PROD_ITEM_SN b set b.ACTION_BY = (

select t.ACTION_BY from BUS_PROD_SN_LOG t order by t.PRODUCT_ITEM_SN_IDX desc limit 0,1 );