摘要:
SELECT COLUMN_NAME 列名, DATA_TYPE 字段类型, CHARACTER_MAXIMUM_LENGTH 长度, COLUMN_TYPE 数据类型, -- IS_NULLABLE 是否为空, COLUMN_DEFAULT 默认值, COLUMN_COMMENT 备注 FROM 阅读全文
摘要:
SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ',') FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'feixmanagedb' AND TABLE_NAME = 'encryptversiontbl 阅读全文
摘要:
SELECT CONCAT( '/// <summary>\r\n/// ', COLUMN_COMMENT, '\r\n/// </summary>\r\npublic ', CASE DATA_TYPE WHEN 'bigint' THEN 'int' WHEN 'tinyint' THEN ' 阅读全文