Show command does not yield any output in Python database

Question

1.00/5 (1 vote)

See more:

So, I am newbie to Sql and database concepts and I wished to create a program which does the basic tasks done in Sql but without using actual commands..

But I do not know why but the show databases and show tables commands does not yield any output and If I try twice for the same in terminal it throws some error

also I am adding in there the output and the error which came when selected the show commands twice

EDIT - just edited the code here to show only SHOW DATABASES command

Thank you for your time

Here is the code

What I have tried:

import mysql.connector

mydb = mysql.connector.connect(
    host = "localhost",
    user = "root",
    password = "mypasswd",)

cursor = mydb.cursor()

cursor.execute("SHOW DATABASES")

Posted 8-Aug-22 7:24am

no name Aug2022

Updated 16-Aug-22 5:57am

v2

Add a Solution

Comments

[no name] 8-Aug-22 14:16pm

Too much going on. Create the database; wrap that up; then move to the next stage / step. Your "create database column" process could benefit from a "for loop" based on column count.

Richard MacCutchan 9-Aug-22 4:21am

Your execution of "SHOW DATABASES" ignores the results so the cursor is left waiting for you to read (or discard) the output. But you should also take Gerry's advice and code and test each part individually. Writing the entire application in this way just makes it more difficult to find and fix problems.

no name Aug2022 16-Aug-22 11:22am

Thank you so much for your answer. I have tried it on a test code, but it didn't make any difference. Although I easily get output on MySQL command line. Alongside even SHOW TABLES command does not seem to give any output ( maybe show command hates me ). I have updated the question and just kept the test code used to use SHOW DATABASE command.

Richard MacCutchan 16-Aug-22 11:39am

I still do not know what you are doing, but the following code works fine and lists all the MySQL databases.

def list_databases(connection):
  mycursor = connection.cursor()

  mycursor.execute('SHOW DATABASES')

  databases = mycursor.fetchall()

  for db in databases:
    print(db)

no name Aug2022 16-Aug-22 11:53am

Thanks a lot , I was doing a really silly mistake. Did not fetch the list of databases for the the output

Richard MacCutchan 16-Aug-22 12:05pm

Which is what I told you a week ago.

no name Aug2022 16-Aug-22 13:19pm

Yes I am sorry I could not get what you said there, but later I realized what you said. Thanks

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2022-08-16T05:57:00

Solution 1

Answered only to remove from unanswered queue: solved by OP.

Posted 16-Aug-22 5:57am

OriginalGriff

Comments

no name Aug2022 16-Aug-22 12:04pm

ok I will accept this