mysql 【with recursive】和json

8月 12, 2022 | Nix.Huang

将json 转换成表使用
select * from json_table('["javacoder", 321, "xyz"]', "$[*]" columns (c1 varchar(26) path '$[0]') ) as t;

mysql 查询层级结构

with recursive cte(id, name, parent_id) as 
(
	select * from ebot.test where id = 1
    union all
    select t.id, t.name, t.parent_id from ebot.test t inner join cte on cte.id = t.parent_id
)
select * from cte;

with recursive cte(id, name, parent_id) as

(

select * from ebot.test where id = 1

union all

select t.id, t.name, t.parent_id from ebot.test t inner join cte on cte.id = t.parent_id

)

select * from cte;

select find_in_set('123', "xyz,123,javacoder.cn") #判断在字符串中是否存在指定的子串，注意空格

Posted in: MySQL practise

知行合一，止于至善

mysql 【with recursive】和json_table使用

站内搜索

知行合一，止于至善

mysql 【with recursive】 和json_table使用

站内搜索

mysql 【with recursive】和json_table使用