Mysql常用方法

获取表信息

SELECT 
    COLUMN_NAME AS '字段名称',
    DATA_TYPE AS '数据类型',
    COLUMN_TYPE AS '字段类型',
    COLUMN_KEY AS '键',
    IS_NULLABLE AS '是否允许为空',
    COLUMN_DEFAULT AS '默认值',
    EXTRA AS '额外属性',
    COLUMN_COMMENT AS '注释'
FROM 
    INFORMATION_SCHEMA.COLUMNS
WHERE 
    TABLE_SCHEMA = 'test'
    AND TABLE_NAME = 'qgyp_ps_st_wnyb_cpq';