python - Python - 写这个的更好的方法

Question

我必须在 python 中执行此操作，而不是编写这么多行 - 还有其他方式吗？

insert into table_a (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_b (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_c (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_d (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_e (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_f (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_g (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_h (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_i (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_j (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_k (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_l (col1,col2,col3) select col1,col2,col3 from temp;

insert into table_m (col1,col2,col3) select col1,col2,col3 from temp;

任何代码指针都会大大有助于参考。

标签： python

Answer 1

如果你只需要它直到一个特定的字母，你可以使用一个包含尽可能多的字母的字符串，然后循环遍历它们。[感谢迈克尔指出]

letters = "abcdefgh"

for letter in letters:
    print(f"insert into table_{letter} (col1,col2,col3) select col1,col2,col3 from temp;")

这将返回：

insert into table_a (col1,col2,col3) select col1,col2,col3 from temp;
insert into table_b (col1,col2,col3) select col1,col2,col3 from temp;
insert into table_c (col1,col2,col3) select col1,col2,col3 from temp;