mysql下的数据排序(concat)->无限极列表时间:2021-09-05 01:34:43 select id,name,pid,path,CONCAT(path,‘-‘,id) as bpath from test ORDER BY bpath