你知道MySQL十条鲜为人知的特殊技巧吗

表A

shell> mysql --xml

mysql> SELECT * FROM test.stories;

1
This is a test

2
This is the second test

2rows in set (0.11 sec)

表B

mysql> REPAIR TABLE content QUICK;
+-----------+--------+----------+----------+
| Table| Op| Msg_type | Msg_text |
+-----------+--------+----------+----------+
| content| repair | status| OK|
+-----------+--------+----------+----------+
1 row in set (0.05 sec)

表C

shell> myisampackmovies.MYI
Compressing movies.MYD: (146 records)
- Calculating statistics
- Compressing file
41.05%