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