1、不要留空行 2、不要前后留空格
1、驼峰命名 (userName) 2、下划线(user_name)
SELECT CONCAT(column_name," ",data_type," ",column_comment) FROM information_schema.COLUMNS WHERE table_schema = 'device' AND table_name = 'biz_device';#表名
device_name VARCHAR 设备名称 address VARCHAR 所在地址