查询ktsee库中user表的数据字典 SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT FROM information_schema.`columns` WHERE TABLE_SCHEMA='ktsee' AND TABLE_NAME='user'
查询ktsee库中每个表占用的控件大小: SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS,concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2), 'MB') as data FROM information_schema.`TABLES` WHERE TABLE_SCHEMA='ktsee' ORDER BY (DATA_LENGTH+INDEX_LENGTH) DESC;