Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and exploring the core foundations for app libraries.
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'"):
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Do you have anything working? Which MySQL driver are you using?
http://dev.mysql.com/downloads/connector/python/
http://dev.mysql.com/downloads/connector/python/
Server version: 5.6.31-ndb-7.4.12-cluster-
Multiple DB and all working.
Trying to do/not do something based on the existence of a table.
Multiple DB and all working.
Trying to do/not do something based on the existence of a table.
I believe you have to process 'SHOW TABLES' and similar queries just like a SELECT query because that is what they are.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial