1、參考表
use information_schema;
2、命令,單位為M
SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows,4),'') AS 'Number of Rows', CONCAT(ROUND(data_length/(1024*1024),4),'') AS 'Data Size', CONCAT(ROUND(index_length/(1024*1024),4),'') AS 'Index Size', CONCAT(ROUND((data_length+index_length)/(1024*1024),4),'') AS'Total'FROM information_schema.TABLES WHERE table_schema LIKE 'bucket_water_db_v11' INTO OUTFILE '/var/lib/mysql-files/bucket.xls';
3、問題：
1）You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':\Users\Administrator\Desktop\b_r0.xls' at line 1----------------->表名要加引號
2）1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement-----------------------》解決如下
mysql> show variables like '%secure%';
+--------------------------+-----------------------+
| Variable_name | Value |
+--------------------------+-----------------------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | /var/lib/mysql-files/ |
+--------------------------+-----------------------+
3 rows in set (0.10 sec)
