i havent done this very long time..may not work..

来源: 于 2006-05-04 17:41:30 [旧帖] [给我悄悄话] 本文已被阅读：次

update table_name
set order_id = (select max(order_id) from table_name) + 1
where order_id = 0;

also lots of other ways...