1. 表a与表b互相转化
考点:字符串判断函数find_in_set, MySQL构造连续数组,分组合并函数group_concat
[a表转化b表]
# 方法一 MySQL #
select a.type ,c.rownum
from a,(SELECT @row:=@row+1 rownum FROM sys.metrics a,(SELECT @row:=0) b) c #Mysql构造连续数
where find_in_set(c.rownu
1. 表a与表b互相转化
考点:字符串判断函数find_in_set, MySQL构造连续数组,分组合并函数group_concat
[a表转化b表]
# 方法一 MySQL #
select a.type ,c.rownum
from a,(SELECT @row:=@row+1 rownum FROM sys.metrics a,(SELECT @row:=0) b) c #Mysql构造连续数
where find_in_set(c.rownu