mysql简单的数据字典所用sql语句

SELECT TABLE_NAME,TABLE_COMMENT,ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = ‘TABLENAME’;

SELECT COLUMN_NAME,COLUMN_TYPE,COLUMN_DEFAULT,IS_NULLABLE,EXTRA,COLUMN_COMMENT,COLUMN_KEY FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = ‘user’ AND table_schema = ‘TABLENAME’;