mysql 語句集錦

標籤：資料庫   mysql   where   

 查看資料庫各表容量大小：

select TABLE_NAME, concat(truncate(data_length/1024/1024,2),‘ MB‘) as data_size,

    concat(truncate(index_length/1024/1024,2),‘ MB‘) as index_size

    from information_schema.tables where TABLE_SCHEMA = ‘cjss‘

    group by TABLE_NAME

    order by data_length desc;

TABLE_SCHEMA 換資料名。

每天每個媒體生採集多少變文章：

SELECT copyfrom,DATE(FROM_UNIXTIME(ext_news.publishtime)),count(*) from ext_news group by copyfrom,DATE(FROM_UNIXTIME(ext_news.publishtime))

建立使用者：

grant all privileges on vtdc.* to ‘joe’@‘10.163.225.87’ identified by ‘123‘;

mysql 語句集錦