MySQL 資料庫與表格查詢的修订

1 file changed, 28 insertions

mysql_database_queries.sql(文件已创建)

		@@ -0,0 +1,28 @@
1	+	SHOW DATABASES;
2	+
3	+	USE myapp;
4	+	SHOW TABLES;
5	+
6	+	SELECT TABLE_NAME, TABLE_ROWS
7	+	FROM INFORMATION_SCHEMA.TABLES
8	+	WHERE TABLE_SCHEMA = 'myapp';
9	+
10	+	SELECT TABLE_NAME,
11	+	ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS SIZE_MB
12	+	FROM INFORMATION_SCHEMA.TABLES
13	+	WHERE TABLE_SCHEMA = 'myapp'
14	+	ORDER BY SIZE_MB DESC;
15	+
16	+	SELECT TABLE_NAME,
17	+	TABLE_ROWS AS RECORDS,
18	+	ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS SIZE_MB
19	+	FROM INFORMATION_SCHEMA.TABLES
20	+	WHERE TABLE_SCHEMA = 'myapp'
21	+	ORDER BY SIZE_MB DESC;
22	+
23	+	SELECT TABLE_SCHEMA AS DATABASE_NAME,
24	+	TABLE_NAME,
25	+	TABLE_ROWS AS RECORDS,
26	+	ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS SIZE_MB
27	+	FROM INFORMATION_SCHEMA.TABLES
28	+	ORDER BY DATABASE_NAME, SIZE_MB DESC;