MySQL分库分表脚本：创建8个库，每个库128张表

#!/bin/bash//n//n# 创建8个分库//nfor ((i=1; i<=8; i++))//ndo//n dbname=/'db$i/'//n mysql -uroot -pYOUR_PASSWORD -e /'CREATE DATABASE IF NOT EXISTS $dbname;/'//ndone//n//n# 创建每个库的128张表//nfor ((i=1; i<=8; i++))//ndo//n dbname=/'db$i/'//n for ((j=1; j<=128; j++))//n do//n tablename=/'table$j/'//n mysql -uroot -pYOUR_PASSWORD -e /'USE $dbname; CREATE TABLE IF NOT EXISTS $tablename (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50));/'//n done//ndone//n//necho /'Done!/