SQL
update a_goods_style s set s.STYLE_IMG=(select STYLE_SKC_IMG from (select a.STYLE_ID, b.STYLE_SKC_IMG from a_goods_style a inner join (select style_id, max(STYLE_SKC_IMG) STYLE_SKC_IMG from a_goods_style_skc where STYLE_SKC_IMG != '无' and STYLE_SKC_IMG is not null group by style_id) b on a.STYLE_ID = b.STYLE_ID where a.STYLE_IMG is null or STYLE_IMG = '无') a where s.STYLE_ID = a.STYLE_ID) WHERE STYLE_IMG is null or STYLE_IMG = '无' and exists(select 1 from (select a.STYLE_ID, b.STYLE_SKC_IMG from a_goods_style a inner join (select style_id, max(STYLE_SKC_IMG) STYLE_SKC_IMG from a_goods_style_skc where STYLE_SKC_IMG != '无' and STYLE_SKC_IMG is not null group by style_id) b on a.STYLE_ID = b.STYLE_ID where a.STYLE_IMG is null or STYLE_IMG = '无')); commit;
c#中string和StringBuilder直接看看执行速度。(2).String类型累计赋值Test  ...
1.全局用户信息设置 git config --global user.name gaojiufeng git config --global user.email 392223903...
git pull https://git.oschina.net/392223903/learn.git master 换为您的git地址...
1.关机Process.Start("shutdown", "-s -t 0"); 2. 注销 Proc...
public static string GetMD5(string str) { //创建MD5对象 MD5 md5 = MD5.C...
方案1.IE浏览器"无法显示此页"的解决办法(1).按下Win+R键打开运行,输入netsh winsock reset,回车;(2).重启即可. 方案2.IE浏览器"无法显示此页"的解决办法 (1).设置-连接-局域网设置-自动检测设置开...