mysql: UPDATE order_comment set type_id=0 where order_id in (select order_id from (select order_id from order_comment where id=36 ) xx )
MS SQLserver:UPDATE order_comment set type_id=0 where order_id in ( select order_id from order_comment where id=36 )
update set where select 组合语句不同数据库的SQL语句的区别