Python Mysql Queary not returning results

Question

I have a DB and when I query a table I get 67 results. The SQL is:

SELECT lower(UserName) from Participants ;

I try to connect to the DB, and I get no connection errors.

def db_connect ():                                                                                                    
    try:                                                                                                              
        cnx = mysql.connector.connect(user=db_user, password=db_password,host=db_host,database=db_name)               
        return cnx                                                                                                    
    except mysql.connector.Error as err:                                                                              
        if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:                                                             
            print("Something is wrong with your user name or password")                                               
        elif err.errno == errorcode.ER_BAD_DB_ERROR:                                                                  
            print("Database does not exist")                                                                          
        else:                                                                                                         
            print(err)  

                                                                                                                      
def main():                                                                                                           
    cnx = db_connect()                                                                                                
    cursor = cnx.cursor()                                                                                             
    query = ("SELECT lower(UserName) from Participants ;")                                                            
    cursor.execute(query)                                                                                             
    print(cursor.rowcount)

It prints out -1 for rowcount. The connection to the DB appears to be working, the SQL is a simple query...

N.Nush · Accepted Answer · 2023-02-08 16:26:29Z

1

Try adding cursor.fetchall() before the print(cursor.rowcount)

answered Feb 8, 2023 at 16:26

N.Nush

1465 bronze badges

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

Collectives™ on Stack Overflow

Python Mysql Queary not returning results

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related