根据库名获取所有表的信息
SELECT
*
FROM
information_schema....`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:
根据库名获取所有的库和表字段的基本信息...*,t1.* FROM (select COLUMN_NAME as '字段',COLUMN_DEFAULT as '默认值',IS_NULLABLE as '允许为空',COLUMN_TYPE as