asked on How can I check the result of mysql query in python?
I've seen lines like op.execute("CREATE LANGUAGE plpgsql") in other scripts in my system so thought I could do similar with the following.
op.execute("SHOW TABLES LIKE 'table_name'")
How can I check the result from this and then do stuff based on existence or not?
I tried result = op.fetchone() but this is incorrect.
AttributeError: 'module' object has no attribute 'fetchone'
and
if not op.execute("SHOW TABLES LIKE 'agents'"):
op.execute("SHOW TABLES LIKE 'table_name'")
How can I check the result from this and then do stuff based on existence or not?
I tried result = op.fetchone() but this is incorrect.
AttributeError: 'module' object has no attribute 'fetchone'
and
if not op.execute("SHOW TABLES LIKE 'agents'"):
Python
Last Comment
mickt
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I believe you have to process 'SHOW TABLES' and similar queries just like a SELECT query because that is what they are.
ASKER
Sorry, I'm not following, can you please clarify for me?
ASKER
I cam across this too.
cursor.execute("SHOW TABLES LIKE 'table_name'")
result = cursor.fetchone()
if result:
"There is a table named table_name."
else:
do stuff
but it complains about cursor
cursor.execute("SHOW TABLES LIKE 'table_name'")
result = cursor.fetchone()
if result:
"There is a table named table_name."
else:
do stuff
but it complains about cursor
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Glad you got it figured out. I had to get some sleep.
ASKER
Answers question.
Multiple DB and all working.
Trying to do/not do something based on the existence of a table.