Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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'"):
Asked:
-
5
3
2 Solutions
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.
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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
http://dev.mysql.com/downloads/connector/python/