mysql解析xml 

select a.id,ExtractValue(a.name, '//root//name') as name

from table t

 

posted @ 2020-09-22 09:30  疯靡  阅读(594)  评论(0)    收藏  举报