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

[joniy]

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里的啊！

[军爷_010]

修改语句不能用order by吧!

[wwwwb]

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);

[ACMAIN_CHM]

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

[qingsoft2000]

3楼正解

[懒得去死]

汗， 既然是等于，那么你的子查询就只有一条记录。 你干嘛要排序？？

[liuhuan851002]

[Quote=引用 3 楼 acmain_chm 的回复:]
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 );
[/Quote]

对!