How to pass table name dynamically to sql query in cursor.execute in Python?

Question

   cur.execute("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE 
   TABLE_NAME LIKE [{}]".format(tableName))

This is my code, but table names are not displaying. Maybe the problem here is in format.

are you looking for table names or columns names ? tables are available with "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE %s" — PRMoureu
– PRMoureu, Commented Nov 3, 2017 at 18:52
I want column name from the table which is stored already in a variable.Thats y : SELECT column_name FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME LIKE %s — Naman Mittal
– Naman Mittal, Commented Nov 3, 2017 at 19:00
so the answer below is the solution, but if you get errors with another part of code, you should add it, or post another question — PRMoureu
– PRMoureu, Commented Nov 3, 2017 at 19:05

Gordon Linoff · Accepted Answer · 2017-11-03 18:35:12Z

1

Use parameters! In Python, this looks like

cur.execute("""
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME LIKE ?""", (tableName))

Some databases may prefer %s rather than ?.

answered Nov 3, 2017 at 18:35

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

1 Comment

Naman Mittal Over a year ago

Once i am using this syntax, the rest of the code isnt working.It works if codecur.execute(""" SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS)code

Collectives™ on Stack Overflow

How to pass table name dynamically to sql query in cursor.execute in Python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related