update cec_item_lib a inner join cec_item_info_lib b on a.item_id = b.item_id set a.status =10 where substring_index(b.categroy,';',1) in ("699","703","807","13529","1410","4978","4979","12323","4902","4105","4117","4108","5272","12402","14692","14374","7191","7192","12854") ;
mysql update join
最新推荐文章于 2024-08-13 16:01:31 发布