MySQL常用语法

#将列合并

SET SESSION group_concat_max_len = 1024000000;
select GROUP_CONCAT(COLUMN_NAME SEPARATOR ',') from information_schema.`COLUMNS` where TABLE_NAME='tab0' and TABLE_SCHEMA='db0'

#将列转换为C#代码

SELECT CONCAT('
/// <summary>
/// ',COLUMN_COMMENT,'
/// </summary>
','public ',DATA_TYPE,' ',COLUMN_NAME,' { get; set; }') as colums from (
SELECT
CASE DATA_TYPE
WHEN 'varchar' THEN 'string'
when 'text' THEN 'string'
WHEN 'datetime' THEN 'DateTime?'
WHEN 'int' THEN 'int?'
WHEN 'tinyint' THEN 'int?'
WHEN 'bigint' THEN 'long?'
ELSE DATA_TYPE END as DATA_TYPE
, COLUMN_NAME,COLUMN_COMMENT from information_schema.`COLUMNS` where TABLE_NAME='tab0' and TABLE_SCHEMA='db0')as newt;