`TABLES`
WHERE
TABLE_SCHEMA = 'erp';
view:
根据库名获取所有的字段信息
SELECT
TABLE_SCHEMA AS '库名',
TABLE_NAME...IS_NULLABLE AS '是否为空',
DATA_TYPE AS '数据类型',
CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',
NUMERIC_PRECISION...COLUMNS`
WHERE
TABLE_SCHEMA = 'erp'
ORDER BY
TABLE_NAME,
ORDINAL_POSITION;
view:
根据库名获取所有的库和表字段的基本信息...'列注释',
C.ORDINAL_POSITION AS '列的排列顺序',
C.COLUMN_DEFAULT AS '默认值',
C.IS_NULLABLE AS '是否为空'...*,t1.* FROM (select COLUMN_NAME as '字段',COLUMN_DEFAULT as '默认值',IS_NULLABLE as '允许为空',COLUMN_TYPE as