mybatis mysql begin end_MySQL #{驼峰字段} for MyBatis

# 查找在那个表并生成 字段名 SQL

SELECT TABLE_SCHEMA, TABLE_NAME, concat(TABLE_SCHEMA, '.', TABLE_NAME) AS st,

concat('SELECT ', group_concat(COLUMN_NAME ORDER BY ORDINAL_POSITION SEPARATOR ', ' ),

' FROM ' , concat(TABLE_SCHEMA, '.', TABLE_NAME) , ';') AS SQLstr

FROM information_schema.COLUMNS WHERE 1=1

AND TABLE_NAME like 'job_depend' GROUP BY TABLE_SCHEMA, TABLE_NAME ORDER BY length(TABLE_SCHEMA);

# 查找多个字段在哪个表 并生成 字段名 SQL

SELECT TABLE_SCHEMA, TABLE_NAME, concat(TABLE_SCHEMA, '.', TABLE_NAME) AS st,

concat('SELECT ', group_concat(COLUMN_NAME ORDER BY ORDINAL_POSITION SEPARATOR ', ' ),

' FROM ' , concat(TABLE_SCHEMA, '.', TABLE_NAME) , ';') AS SQLstr

FROM information_schema.COLUMNS WHERE 1=1

AND TABLE_NAME in ('job_depend','job_id') GROUP BY TABLE_SCHEMA, TABLE_NAME

HAVING count(TABLE_NAME)>=2 ORDER BY length(TABLE_SCHEMA);

# #{驼峰字段} (创建存储函数snakeToCamel后使用)

SELECT TABLE_SCHEMA, TABLE_NAME,

snakeToCamel(group_concat(concat('#{',COLUMN_NAME,'}')

ORDER BY ORDINAL_POSITION SEPARATOR ', ')) AS COLUMN_NAMES

FROM information_schema.COLUMNS WHERE 1=1

AND TABLE_NAME like 'job_depend&#