mysql清除所有表数据

-- 获取所有表名
SELECT CONCAT('TRUNCATE TABLE ', table_name, ';') 
INTO OUTFILE '/tmp/all_tables_truncate.sql' 
FROM information_schema.tables 
WHERE table_schema = 'your_database_name';

-- 执行生成的SQL文件
SOURCE /tmp/all_tables_truncate.sql;

#!/bin/bash

# 数据库连接信息
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database_name"

# 获取所有表名
TABLES=$(mysql -u$DB_USER -p$DB_PASS -N -e "SELECT table_name FROM information_schema.tables WHERE table_schema='$DB_NAME'")

# 清空所有表数据
for TABLE in $TABLES; do
    mysql -u$DB_USER -p$DB_PASS -e "TRUNCATE TABLE $TABLE;"
done

echo "All tables in $DB_NAME have been truncated."