mysql如何查詢所有表和字段信息

SELECT ????* FROM ????information_schema.`TABLES` WHERE ????TABLE_SCHEMA?=?'erp';

SELECT ????TABLE_NAME, ????TABLE_COMMENT FROM ????information_schema.`TABLES` WHERE ????TABLE_SCHEMA?=?'erp';

SELECT ????TABLE_SCHEMA?AS?'庫名', ????TABLE_NAME?AS?'表名', ????COLUMN_NAME?AS?'列名', ????ORDINAL_POSITION?AS?'列的排列順序', ????COLUMN_DEFAULT?AS?'默認值', ????IS_NULLABLE?AS?'是否為空', ????DATA_TYPE?AS?'數(shù)據(jù)類型', ????CHARACTER_MAXIMUM_LENGTH?AS?'字符最大長度', ????NUMERIC_PRECISION?AS?'數(shù)值精度(最大位數(shù))', ????NUMERIC_SCALE?AS?'小數(shù)精度', ????COLUMN_TYPE?AS?列類型, ????COLUMN_KEY?'KEY', ????EXTRA?AS?'額外說明', ????COLUMN_COMMENT?AS?'注釋' FROM ????information_schema.`COLUMNS` WHERE ????TABLE_SCHEMA?=?'erp' ORDER?BY ????TABLE_NAME, ????ORDINAL_POSITION;

SELECT ????C.TABLE_SCHEMA?AS?'庫名', ????T.TABLE_NAME?AS?'表名', ????T.TABLE_COMMENT?AS?'表注釋', ????C.COLUMN_NAME?AS?'列名', ????C.COLUMN_COMMENT?AS?'列注釋', ????C.ORDINAL_POSITION?AS?'列的排列順序', ????C.COLUMN_DEFAULT?AS?'默認值', ????C.IS_NULLABLE?AS?'是否為空', ????C.DATA_TYPE?AS?'數(shù)據(jù)類型', ????C.CHARACTER_MAXIMUM_LENGTH?AS?'字符最大長度', ????C.NUMERIC_PRECISION?AS?'數(shù)值精度(最大位數(shù))', ????C.NUMERIC_SCALE?AS?'小數(shù)精度', ????C.COLUMN_TYPE?AS?列類型, ????C.COLUMN_KEY?'KEY', ????C.EXTRA?AS?'額外說明' FROM ????information_schema.`TABLES`?T LEFT?JOIN?information_schema.`COLUMNS`?C?ON?T.TABLE_NAME?=?C.TABLE_NAME AND?T.TABLE_SCHEMA?=?C.TABLE_SCHEMA WHERE ????T.TABLE_SCHEMA?=?'erp'? ORDER?BY ????C.TABLE_NAME, ????C.ORDINAL_POSITION;