質問編集履歴
1
テーブルのステータスを表示する方法があったのでそちらも記載します。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -24,6 +24,28 @@
|
|
|
24
24
|
+------------+---------+------+
|
|
25
25
|
| kato@gmail | kato123 | ???? |
|
|
26
26
|
+------------+---------+------+
|
|
27
|
+
|
|
28
|
+
MariaDB [test]> show table status;
|
|
29
|
+
+---------+--------+---------+------------+------+----------------+-------------
|
|
30
|
+
+-----------------+--------------+-----------+----------------+-----------------
|
|
31
|
+
----+-------------+------------+-----------------+----------+----------------+--
|
|
32
|
+
-------+
|
|
33
|
+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length
|
|
34
|
+
| Max_data_length | Index_length | Data_free | Auto_increment | Create_time
|
|
35
|
+
| Update_time | Check_time | Collation | Checksum | Create_options | C
|
|
36
|
+
omment |
|
|
37
|
+
+---------+--------+---------+------------+------+----------------+-------------
|
|
38
|
+
+-----------------+--------------+-----------+----------------+-----------------
|
|
39
|
+
----+-------------+------------+-----------------+----------+----------------+--
|
|
40
|
+
-------+
|
|
41
|
+
| mylogin | InnoDB | 10 | Compact | 2 | 8192 | 16384
|
|
42
|
+
| 0 | 0 | 0 | NULL | 2016-02-02 13:33
|
|
43
|
+
:54 | NULL | NULL | utf8_general_ci | NULL | |
|
|
44
|
+
|
|
|
45
|
+
+---------+--------+---------+------------+------+----------------+-------------
|
|
46
|
+
+-----------------+--------------+-----------+----------------+-----------------
|
|
47
|
+
----+-------------+------------+-----------------+----------+----------------+--
|
|
48
|
+
-------+
|
|
27
49
|
```
|
|
28
50
|
|
|
29
51
|
###補足情報(言語/FW/ツール等のバージョンなど)
|