SELECT
CONCAT(UPPER(LEFT(column_name,1)),SUBSTRING(column_name,2,(LENGTH(column_name)-1))) AS column_name,
data_type,xx,column_comment
FROM (SELECT DISTINCT REPLACE(column_name,'_','') AS column_name,
CASE data_type
WHEN 'varchar' THEN 'string'
WHEN 'datetime' THEN 'string'
WHEN 'longtext' THEN 'string'
WHEN 'tinyint' THEN 'int'
WHEN 'bigint' THEN 'int64'
WHEN 'double' THEN 'float64'
ELSE data_type END AS data_type,
CONCAT('`json:"', column_name ,'"', ' sql:"', column_name,'"`') AS xx,
CONCAT('//',column_comment) AS column_comment
FROM Information_schema.COLUMNS
WHERE TABLE_NAME = 'appstore_order_record'
AND TABLE_SCHEMA = 'log')t