mysql清空所有表格数据

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

-- 删除外键约束
ALTER TABLE table_name DROP FOREIGN KEY foreign_key_name;

-- 清空表数据
TRUNCATE TABLE table_name;

-- 重新创建外键约束
ALTER TABLE table_name ADD CONSTRAINT foreign_key_name FOREIGN KEY (column_name) REFERENCES other_table(other_column);

-- 提交事务
COMMIT;

-- 清空表数据
TRUNCATE TABLE table_name;

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

cursor = db.cursor()

# 获取所有表名
cursor.execute("SHOW TABLES")
tables = cursor.fetchall()

# 清空每个表的数据
for table in tables:
    cursor.execute(f"TRUNCATE TABLE {table[0]}")

# 提交事务
db.commit()

# 关闭连接
cursor.close()
db.close()