Mysql

2020-11-19moonygao阅读(1510)评论(0)赞(1)

单独查询某个表的注释、字段 selectTABLE_NAME AS ‘表名’,COLUMN_NAME AS ‘字段名’,COLUMN_TYPE AS ‘数据类型’,co...

2020-09-22moonygao阅读(1306)评论(0)赞(0)

mysql查询数据库大小： select concat(round(sum(DATA_LENGTH/1024/1024),2),’MB’) as data  from information_schema.TABLE...

2019-08-07moonygao阅读(2054)评论(0)赞(0)

2019-07-16moonygao阅读(1587)评论(0)赞(0)

折腾了半天才发现原来是在连接mysql时没有”-u”参数导致的 D:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -uroot 重新连接mysql　加上-u参数...

2019-07-16moonygao阅读(1555)评论(0)赞(0)

use information_schema; select concat(round(sum(data_length/1024/1024),2),’MB’) as data from tables where TA...