擅长:python、mysql、java
<p>尽管我个人认为您应该使用一些解析库来解析SQL的AST,但是通过查看代码也可以使用此选项:</p>
<pre><code>my_sql_code = '''DROP TABLE...''' #big long string, multiline
statements = my_sql_code.split(';')
statements = [s for s in statements if 'tableB' in s]
for s in statements:
execute_sql(s)
</code></pre>