#!/bin/bash

创建8个分库

for ((i=1; i<=8; i++)) do dbname="db$i" mysql -uroot -pYOUR_PASSWORD -e "CREATE DATABASE IF NOT EXISTS $dbname;" done

创建每个库的128张表

for ((i=1; i<=8; i++)) do dbname="db$i" for ((j=1; j<=128; j++)) do tablename="table$j" mysql -uroot -pYOUR_PASSWORD -e "USE $dbname; CREATE TABLE IF NOT EXISTS $tablename (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50));" done done

echo "Done!"