SELECT ys.id,ys.productname,ys.dirname,ysb.dirname AS bdirname,ysb.nickname,ysb.productname,ysb.salesnum FROM yzj_singlelist ys, yzj_singlelistbak ysb WHERE ys.productname LIKE CONCAT('%',ysb.nickname,'%') AND ysb.nickname !="" AND ysb.dirname="" ORDER BY ysb.salesnum DESC;
UPDATE yzj_singlelist ys JOIN yzj_singlelistbak ysb ON ys.dirname=ysb.dirname SET ys.salesnum =ysb.salesnum;
一个字段值为条件查询另一张表值
浏览：664
编辑：绿萝
来源：绿萝
SELECT ys.id,ys.productname,ys.dirname,ysb.dirname AS bdirname,ysb.nickname,ysb.productname,ysb.sale
上一篇：
Ç与C的差异性
下一篇：
检查mysql是否成功启动的方法(bat+bash)
