mysql数据库清空所有数据库表

SELECT CONCAT('TRUNCATE TABLE ', table_name, ';') 
INTO OUTFILE '/tmp/truncate_tables.sql' 
FROM information_schema.tables 
WHERE table_schema = 'your_database_name';

mysql -u your_username -p your_database_name < /tmp/truncate_tables.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 $DB_NAME -e "TRUNCATE TABLE $TABLE;"
done