Return console commands using python and mysql

Question

I'm trying to make a python program which uses python to interact with MySQL. What I want to do is to have the program return and store into a variable the return of that command variable.

For example, if I entered into the MySQL command line SHOW tables;, it would show me all the tables, and it would look something like this:

+----------------+
| Tables_in_test |
+----------------+
| food           |
| games          |
| movies         |
+----------------+

I want to know if there's any way to get that output into, for instance, a variable in python.

Thanks!

Ampati Hareesh · Accepted Answer · 2017-08-14 10:59:21Z

0

Write a stored procedure where it uses the cursor.

cursor contains the rows of the command SHOW tables

when you call the sp through your code[python] you can get the results

answered Aug 14, 2017 at 10:59

Ampati Hareesh

1,8721 gold badge18 silver badges20 bronze badges

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

4 Comments

JonnyNich Over a year ago

What I want is for the program not requiring a previous knowledge of the tables in the database, but that it uses the result of the code and stores it in a variable.

Ampati Hareesh Over a year ago

unable to get what exactly u want to achieve, would u like to elaborate ?

JonnyNich Over a year ago

I was a way to get the output of the console into a variable. For example, if I typed 'show tables;", the result of that would be put into a variable. That result would be the table shown above.

Ampati Hareesh Over a year ago

if i understood it correctly, you want the sql command output to be stored into a variable[pyhton] As i mentioned earlier, please look into the following items[select ..into , cursor, storedprocedure ] if that is not your requirement , then this might help you stackoverflow.com/questions/10070406/…

Collectives™ on Stack Overflow

Return console commands using python and mysql

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related