1、c# 65*1.0F/102=0.637254901960784
2、mysql TRUNCATE(65/102,9) 9代表的是保留几位小数
3、多张表关联,修改某张表的字段
UPDATE shoppart.goodsimages t1,shoppart.orderdetails t2 SET t2.s_goodsimg=t1.gi_imgurl
WHERE t1.gi_gid=t2.s_goodsid AND t1.gi_property=1
1、c# 65*1.0F/102=0.637254901960784
2、mysql TRUNCATE(65/102,9) 9代表的是保留几位小数
3、多张表关联,修改某张表的字段
UPDATE shoppart.goodsimages t1,shoppart.orderdetails t2 SET t2.s_goodsimg=t1.gi_imgurl
WHERE t1.gi_gid=t2.s_goodsid AND t1.gi_property=1