sql 脚本编写 行转列 列转行

1. sql 脚本编写 行转列 列转行

表设计

test_table

id varchar(11),

namevarchar(255),

table_desc varchar(255)

sql 编写

行转列

selectconcatenate("id",""),

concatenate("name",""),

concatenate("desc",""),

concatenate(

""

,(

select*

from test_table a

where1=1

limit1

desc

)

)

from test_table b

列转行

selectconcatenate("id",""),*

from test_table a

union

(

selectb.id

from test_table b

limit1

desc

)

;

#牛客AI配图神器#