mysql 常用函数date_format,解析日期,json_extract,解析json

1.date_format,解析日期

DATE_FORMAT(ei.create_date,'%y-%m-%d') date

2.json_extract,解析json

SELECT
    json_extract( t.ext, '$.*' ),
    json_extract( t.ext, '$.system' ) AS "system",
    json_extract( t.ext, '$.user' ) AS "user" ,
    json_extract( t.ext, '$**.user' ) AS "user2" 
FROM
    sys_user  t;