##mysql 查看表结构
SELECT
COLUMN_NAME 'Field',
COLUMN_TYPE 'Type',
IS_NULLABLE 'Null',
COLUMN_KEY 'Key',
COLUMN_DEFAULT 'Default',
COLUMN_COMMENT 'Comment'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = 'dbname' ##数据库名
AND table_name = 'tableName' ##数据库表名
##mysql 查...