![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
yonhu123java
这个作者很懒,什么都没留下…
展开
-
行列转换
行转列方法一:通过CASE WHEN语句SELECT username, max(CASE WHEN subject = '语文' THEN score END) AS `语文`, max(CASE WHEN subject = '数学' THEN score END) AS `数学`, max(CASE WHEN subject = '英语' THEN score END) AS `英语`FROM pivotGROUP BY usernameORDER BY use.原创 2020-09-07 10:21:38 · 302 阅读 · 0 评论 -
利用mysql函数快速建立分表语句
BEGIN#Routine body goes here…declare i int;declare num varchar(2);set i=0;set num = “0”;while i<32 doset num = concat("",i);– IF i < 10 THEN– set num = concat(“0”,i);– END IF;set @sql_drop_table = concat(‘drop TABLE IF EXISTS t_user_’, nu原创 2020-07-13 14:45:20 · 441 阅读 · 0 评论