How to pass database name as a parameter to sql statement in python?

Question

I have different sql statements(create, insert,delete, update,...) in python that I want to execute them for different databases,and I want to pass database name as a parameter to sql statements. example: query = """ SELECT * FROM [mainDB].[dbo].[customer] """

Replace [mainDB] with a variable name => query = "SELECT * FROM "+ dataBaseName +".[dbo].[customer] " — Kobi
– Kobi, Commented Aug 3, 2018 at 15:51

Kobi · Accepted Answer · 2018-08-03 15:58:33Z

1

you should replace [mainDB] with a variable name in your query => "SELECT * FROM "+ dataBaseName +".[dbo].[customer] "

You can set a list of database name and loop on this list to perform your query

for i, dbName in enumerate(['mydb', 'otherdb', 'thirddb']):
     print("SELECT * FROM ["+ dbName +"].[dbo].[customer];")

answered Aug 3, 2018 at 15:58

Kobi

2,52418 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass database name as a parameter to sql statement in python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related