linux 批量创建表命令

#第一种：
#!/bin/sh
#creat tables
for i in `seq 1 511`
do
    var=`printf "%02d\n" $i`
   
    echo '''
CREATE TABLE `pt_account_'''$var'''` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `domain_id` bigint(20) NOT NULL COMMENT '账号域id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_domain_wid` (`domain_id`,`wid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='测试表';
''' >> test.txt
  
    echo
done

#!/bin/bash
#批量创建数据表
for y in {6..511};do
mysql -uroot -p123 -e "use db_passport_1; create table pt_account_$y(
  id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  domain_id bigint(20) NOT NULL COMMENT '账号域id',
  PRIMARY KEY (id),
  UNIQUE KEY uk_domain_wid (domain_id,wid) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='测试表';"
done