清空所有表SQLmysql -N -s information_schema -e "SELECT CONCAT('TRUNCATE TABLE ',TABLE_NAME,';') FROM TABLES WHERE TABLE_SCHEMA='TABLE_NAME'" | mysql -f TABLE_NAME...

阅读全文 »