MENU

运动鞋改规格(临时笔记)

July 30, 2018 • Read: 486 • linux阅读设置

SELECT b.*,c.* from nr_order a,nr_order_product b, nr_order_option c
 WHERE a.id=b.order_id and b.id=c.order_product_id and a.order_number='NR807292006195456';

select * from nr_order_option where id in(
 SELECT c.id from nr_order a,nr_order_product b, nr_order_option c
 WHERE a.id=b.order_id and b.id=c.order_product_id and a.order_number='NR807292006195456');

#update nr_order_product b, nr_order_option c set c.poid=212774 where b.id=c.order_product_id and b.goods_id=107284 and b.id=3252063


select poid,options_value,`status`,chinese_pice from nr_product_options where status=1 and goods_id='107284';

SELECT status,poid,options_value FROM nr_product_options WHERE options_value LIKE '%84765,84770%'

select * from gwms.nr_stock where poid=454496;

284330
284335
284330

84765,84771
84765,84773
84765,84770

兼总条贯 知至知终

无标签