How to format sql statement in Python

Asked Nov 09 '20 at 08:04

Active Nov 09 '20 at 08:16

Viewed 119 times

i have a small problem with formatting in Python. My code is:

sql_statement="""
INSERT INTO {target}.{table}
SELECT COL1,COL2
FROM {src}.{table}
WHERE Id = 999 """.format(table=table,src=src,target=target)
cur.execute(sql_statement)

Every time when i print this sql_statement INSERT,SELECT,FROM and WHERE are shifted by one tab right in the terminal. How can i format this correct? Also if i put INSERT into a first like where sql_statement is INSERT is printed ok.

sql_statement="""INSERT INTO {target}.{table}
SELECT COL1,COL2
...

edited Nov 09 '20 at 08:08

asked Nov 09 '20 at 08:04

Anthony Potter

You've misspelled `INSERT`. – Barmar Nov 09 '20 at 08:05
I don't understand the problem. SQL doesn't care about whitespace in the query. – Barmar Nov 09 '20 at 08:06
But I don't see any reason why they would be indented by a tab if the code is as you show. – Barmar Nov 09 '20 at 08:07
Yes this code works perfect and sql doesn’t care about the TAB. But i am not sure why if i print the sql statement i get extra TAB in my print. It’s not a problem in the working, problem is because i cannot figure out why print puts extra space – Anthony Potter Nov 09 '20 at 08:11
1

Is the code inside a function definition? Is it indented there? – Barmar Nov 09 '20 at 08:12
Prints fine and untabbed for me... – Tomerikoo Nov 09 '20 at 08:17
How do you print the statement? – Ken Y-N Nov 09 '20 at 08:17
@AnthonyPotter since your question has been closed I cannot answer here, but I [added my anwer](https://stackoverflow.com/a/64748090/4349415) to the linked dupe. – Mike Scotty Nov 09 '20 at 08:29
Yes it’s inside a function and inside a for loop – Anthony Potter Nov 09 '20 at 08:47

How to format sql statement in Python

0 Answers0