MySQL - REPAIR 修复表

要通过 Node.js 程序修复 MySQL 数据库中的表，我们需要使用 mysql2 库中的 query() 函数执行 Repair Table 语句，如下所示:-

sql=" REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_name] ...
[QUICK] [EXTENDED] [USE_FRM]";
con.query(sql);

要通过 Java 程序修复 MySQL 数据库中的表，我们需要使用 JDBC 函数 executeUpdate() 执行 Repair Table 语句，如下所示:-

String sql="Repair TABLE table_names";
statement.executeUpdate(sql);

要通过 Python 程序修复 MySQL 数据库中的表，我们需要使用 MySQL Connector/Python 的 execute() 函数执行 Repair Table 语句，如下所示:-

sql="REPAIR TABLE table_name";
cursorObj.execute(sql);

var mysql = require('mysql2');
var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "Nr5a0204@123"
});
 //连接到 MySQL
  con.connect(function (err) {
  if (err) throw err;
  console.log("Connected!");
  console.log("--------------------------");
 sql = "Create Database TUTORIALS"
  con.query(sql);
 sql = "USE TUTORIALS"
  con.query(sql);
 sql = "CREATE TABLE sales(ID INT, ProductName VARCHAR(255), CustomerName VARCHAR(255), DispatchDate date, DeliveryTime time, Price INT, Location VARCHAR(255));"
  con.query(sql);
 sql = "insert into sales values(1, 'Key-Board', 'Raja', DATE('2019-09-01'), TIME('11:00:00'), 7000, 'Hyderabad'),(2, 'Earphones', 'Roja', DATE('2019-05-01'), TIME('11:00:00'), 2000, 'Vishakhapatnam'),(3, 'Mouse', 'Puja', DATE('2019-03-01'), TIME('10:59:59'), 3000, 'Vijayawada'),(4, 'Mobile', 'Vanaja', DATE('2019-03-01'), TIME('10:10:52'), 9000, 'Chennai'),(5, 'Headset', 'Jalaja', DATE('2019-04-06'), TIME('11:08:59'), 6000, 'Goa');"
  con.query(sql);
 sql = "ALTER TABLE Sales ENGINE = MyISAM;"
  con.query(sql);
 sql = "REPAIR TABLE Sales;"
  con.query(sql, function(err, result){
    if (err) throw err
    console.log(result);
  });
});

输出

生成的输出如下 -

Connected!
--------------------------
[
  {
    Table: 'tutorials.sales',
    Op: 'repair',
    Msg_type: 'status',
    Msg_text: 'OK'
  }
]

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class RepairTable{
        public static void main(String[] args){
            String url = "jdbc:mysql://localhost:3306/TUTORIALS";
            String username = "root";
            String password = "password";
            try{
                Class.forName("com.mysql.cj.jdbc.Driver");
                Connection connection = DriverManager.getConnection(url, username, password);
                Statement statement = connection.createStatement();
                System.out.println("Connected successfully...!");
               //Repair tables...!
                String sql = "REPAIR TABLE customers";
                statement.executeUpdate(sql);
                System.out.println("Table repaired successfully...!");
               connection.close();
            }
            catch(Exception e){
                System.out.println(e);
            }
        }
}

输出

获得的输出如下所示 -

Connected successfully...!
Table repaired successfully...!

import mysql.connector
#建立连接
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
table_name = 'tutorials_tbl_temp'
#创建游标对象
cursorObj = connection.cursor()
repair_table_query = f"REPAIR TABLE {table_name}"
cursorObj.execute(repair_table_query)
print(f"Table '{table_name}' is repaired successfully.")
# 获取并使用游标中剩余的结果
# 确保在关闭游标之前没有未读的结果。
for _ in cursorObj:
    pass
cursorObj.close()
connection.close()

输出

以下是上述代码的输出 -

Table 'tutorials_tbl_temp' is repaired successfully.