随笔分类 -  Mysql

mysql 根据两张表的相同字段 更新其中一张表的对应行的数据
摘要：UPDATE fahuolog a,jiamengshang_apply b SET a.uid=b.`uid` WHERE a.`ssn`=b.`ssn` 阅读全文
posted @ 2019-05-16 16:43 label_xl 阅读(1018) 评论(0) 推荐(0)
mysql 先分组排序 后加序号
摘要：select @i:=@i+1,tnum from (SELECT ssn,SUM(snum) AS tnum FROM v_fahuolog_jmsapply_vip where proid='0010001' GROUP BY uid order by tnum desc) as t,(sele 阅读全文
posted @ 2019-05-16 12:42 label_xl 阅读(486) 评论(0) 推荐(0)