RT：一個表存盤了欄位名和注釋，例如下面的陳述句：
select group_concat(CONCAT(a.column_name,' as ',b.`DESC`)) as dd from information_schema.COLUMNS a join TD_OA.bpm_variable b on a.column_name=b.name where a.TABLE_NAME='bpm_data_15'
結果是：
data_m239 as 填表日期,data_m240 as 姓名,data_m241 as 部門,data_m242 as 職務,data_m243 as 出生日期,data_m244 as 籍貫,data_m245 as 學歷,data_m246 as 身份證,data_m247 as 入職,data_m248 as 工號,data_m249 as 手機,data_m250 as 郵箱,data_m251 as 是否有照片,data_m252 as 是否有檔案表,data_m253 as 是否有身份證,data_m254 as 是否有學位證,data_m255 as 其他證件,data_m256 as 分配電話,data_m258 as 人事部經辦人,data_m259 as 分配電子郵件,data_m260 as 開設OA賬號,data_m261 as 分配電腦,data_m263 as 系統經辦人,data_m264 as 指紋考勤,data_m265 as 基本辦公用品登記,data_m267 as 行政經辦人,data_m269 as 部門經辦人,data_m271 as 總經理經辦人,data_m273 as 新員工經辦人
而這個結果正是bpm_data_15這個表的欄位，我的想法是把英文欄位轉成中文，看起來直觀一些。
但用下面的陳述句不行
SELECT replace((select group_concat(CONCAT(a.column_name,' as ',b.`DESC`)) as dd from information_schema.COLUMNS a join TD_OA.bpm_variable b on a.column_name=b.name where a.TABLE_NAME='bpm_data_15'),'\"','') from bpm_data_15
想請教一下，能不能把查詢結果變成表認可的欄位？先謝謝大家。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/48401.html
標籤：MySQL
上一篇：一條SqlServer的觸發器陳述句轉換為mysql的觸發器陳述句
下一篇：mysql-5.7.10-winx64 在組態檔[mysqld]下加入 skip-grant-tables還是出現ERROR1045