mysql - 缩小mysql表

Question

有人可以帮我优化/缩小此表，以便正确显示。我尝试了以下命令但没有成功。

优化表；

更改表 ROW_FORMAT = 压缩；

| teamstats_id | Trade_id | home_team_corners | away_team_corners | home_team_cards                                                                                                  | away_team_cards                                                   |
+--------------+----------+-------------------+-------------------+------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------+
|            1 |        1 |                 7 |                 4 | 74` Hong Jung-Woon, 94` Kim Woo-Seok                                                                             | NONE                                                              |
|            2 |        2 |                 3 |                 1 | 39` Suchy                                                                                                        | 53` Otavio, 73` Arnold, 93` Rousillon                             |
|            3 |        3 |                 5 |                 1 | 24` Kostic, 36` N`Dicka, 59` Silva An., 70` Ilsanker, 89` Kohr                                                   | 9` Elvedi                                                         |
|            4 |        4 |                 2 |                 6 | 66` Filipenko, 85` Nastic                                                                                        | 16` Koanda, 18` Cheboatev, 23` Tetrenko, 85` Koroev               |
|            5 |        5 |                 6 |                 9 | 4` Kuchinski, 9` Bordukov, 31` Bashilov, 47` Nechaev, 82` Yasukevich, 90` Yasukevich, 91` Solanovich, 94` Glebko | 17` Nazarenko, 25` Carioca, 29` Matveenko, 32` Cesar              |
|            6 |        6 |                 5 |                 6 | 22` Tikhonovsky, 67` Sedko, 72` Migunov                                                                          | 87` Vakulich                                                      |
|            7 |        7 |                 0 |                 0 | 40` RED Musayibov                                                                                                | NONE                                                              |
|            8 |        8 |                 2 |                 9 | 54` Moisander, 75` Friedl                                                                                        | 44` Bender                                                        |
|            9 |        9 |                 2 |                 9 | 54` Moisander, 75` Friedl                                                                                        | 44` Bender                                                        |
|           10 |       38 |                 0 |                 0 | NONE                                                                                                             | NONE                                                              |
|           11 |       39 |                 0 |                 0 | 10` Miil, 65` Kelder, 71` Opp, 80` Pajunurm, 86` Schjonnin-Larsen                                                | 51` Khomutov, 52` Subbotin, 59` Volkov, 82` Raudsepp, 93` Demitov |
|           12 |       40 |                 0 |                 0 | 38` Kauber, 87` Sinilaid                                                                                         | 58` Juhkam                                                        |

标签： mysql