清除mysql库数据

START TRANSACTION;
DELETE FROM table_name;
-- 如果一切正常，提交事务
COMMIT;
-- 如果发现问题，回滚事务
ROLLBACK;

GRANT DELETE ON database_name.* TO 'username'@'host';
FLUSH PRIVILEGES;

import mysql.connector
from mysql.connector import Error

def delete_data():
    try:
        connection = mysql.connector.connect(host='localhost',
                                             database='database_name',
                                             user='username',
                                             password='password')
        if connection.is_connected():
            cursor = connection.cursor()
            cursor.execute("DELETE FROM table_name")
            connection.commit()
            print("Data deleted successfully")
    except Error as e:
        print("Error while connecting to MySQL", e)
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()
            print("MySQL connection is closed")

delete_data()