1.查询表的表结构
根据表名查询表结构相关的内容
SELECT
*
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'ods'
AND TABLE_NAME = 'ods_mes_m_line'
根据表名查询表结构相关的内容
SELECT
*
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'ods'
AND TABLE_NAME = 'ods_mes_m_line'