CSV 存储引擎支持 CHECK TABLE 和 REPAIR TABLE 语句，用于验证并在可能的情况下修复损坏的 CSV 表。The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table.

在运行CHECK TABLE语句时，CSV文件会通过检查正确的字段分隔符、转义字段（匹配或缺失的引号）、与表定义相比的正确字段数以及相应的CSV元文件的存在来验证其有效性。发现的第一个无效行会导致错误。检查有效表会产生如下所示的输出：When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field separators, escaped fields (matching or missing quotation marks), the correct number of fields compared to the table definition and the existence of a corresponding CSV metafile. The first invalid row discovered causes an error. Checking a valid table produces output like that shown here:

mysql> CHECK TABLE csvtest;
+--------------+-------+----------+----------+
| Table        | Op    | Msg_type | Msg_text |
+--------------+-------+----------+----------+
| test.csvtest | check | status   | OK       |
+--------------+-------+----------+----------+

对损坏表的检查会返回如下错误A check on a corrupted table returns a fault such as

mysql> CHECK TABLE csvtest;
+--------------+-------+----------+----------+
| Table        | Op    | Msg_type | Msg_text |
+--------------+-------+----------+----------+
| test.csvtest | check | error    | Corrupt  |
+--------------+-------+----------+----------+

要修复表，请使用 REPAIR TABLE，它会尽可能从现有的 CSV 数据中复制有效行，然后用恢复的行替换现有的 CSV 文件。超过损坏数据的行将丢失。To repair a table, use REPAIR TABLE, which copies as many valid rows from the existing CSV data as possible, and then replaces the existing CSV file with the recovered rows. Any rows beyond the corrupted data are lost.

mysql> REPAIR TABLE csvtest;
+--------------+--------+----------+----------+
| Table        | Op     | Msg_type | Msg_text |
+--------------+--------+----------+----------+
| test.csvtest | repair | status   | OK       |
+--------------+--------+----------+----------+