sync_replica_dropTable_background.sim 301 字节
Newer Older
H
Hui Li 已提交
1 2 3 4 5
sql connect

$db = db
$stb = stb
print =============== sync_replica_dropTable_background.sim step0: drop table
H
Hui Li 已提交
6
$totalTableNum = 6
H
Hui Li 已提交
7 8 9 10

sql use $db

$tblNum = $totalTableNum
H
Hui Li 已提交
11
$dropTblNum = 6
H
Hui Li 已提交
12 13 14 15 16 17 18

$i = 1
while $i < $dropTblNum
  $tb = tb . $i
  sql drop table if exists $tb
  $i = $i + 1
endw