mysql
阳仔928
不断学习
展开
-
mysql排名
1.排名可重复SELECT @rownum:=@rownum+1AS rownum,if(@total=total,@rank,@rank:=@rownum)as rank,@total:=total,A.name FROM(SELECTSUM(score)AS total,nameFROM student_infoGROUPBY nameORDER原创 2016-10-10 17:08:23 · 411 阅读 · 0 评论 -
面试题回忆
1.mysql 表关联更新: update table1 t1,table2 t2 set t1.name = t2.name where t1.id=t2.id; UPDATE table1 t1 LEFT/RIGHTJOIN table2 t2 ON t1.id=t2.idSET t1.name = t2.name2.唯一索引和主键区别 唯一索引和基本...原创 2019-03-22 18:46:55 · 134 阅读 · 0 评论