给自己做个记录,
#!/bin/bash
for i in $(seq 0 100)
do
echo $i
mysql -uroot -p12sa3456 -h192.168.199.11 << EOF
use bbs
CREATE TABLE reverts_add_$i(
rid INT(20) DEFAULT 0 PRIMARY KEY NOT NULL,
backfid INT(20) DEFAULT 0,
revert_total INT(20) DEFAULT 0
)ENGINE = MyISAM DEFAULT CHARACTER SET= UTF8;
EOF
done