shell 脚本VS存储过程针对1024张分表 更新操作记录

### 新建sh文件
```
for i in $(seq 0 127)
do
mysql -u"$1" -p"$2" -e "use tption0;alter table tption_order_ $i add index idx_settlement_time (settlement_time);"
done
```

### 设置权限
`chmod 755 tption_order_update_index.sh`

### 执行
```
./tption_order_update_index.sh root '123456' > tption_order_update_index_result.log

DELIMITER $$
CREATE PROCEDURE `truncateData`()
begin
declare i int;
declare j int;
 set i=0;
    while i<128 do
  select "进入i",i;
  set @delSqlStr=concat("truncate table t_u_messages_",i);
        PREPARE trunStmt from @delSqlStr;
        EXECUTE trunStmt;
        set i=i+1;
   end while;
end
$$
DELIMITER;
call truncateData();
DROP PROCEDURE IF EXISTS truncateData;

DELIMITER $$
CREATE PROCEDURE `truncateData`()
begin
declare i int;
declare j int;
 set i=0;
    while i<36 do
  select "进入i",i;
  set @delSqlStr=concat("truncate table t_messages_",i);
        PREPARE trunStmt from @delSqlStr;
        EXECUTE trunStmt;
        set i=i+1;
   end while;
end
$$
DELIMITER;
call truncateData();
DROP PROCEDURE IF EXISTS truncateData;