Foro de elhacker.net

mysql.connector.errors.ProgrammingError 1054 (42S22): Unknown column 'cod_test in 'where clause'

import mysql.connector

user     = ""
password = ""
host     = ""
db       = ""

mi_database = mysql.connector.connect(user=user, 
                                      password=password, 
                                      host=host, 
                                    database=db)
puntero = mi_database.cursor()



def run_query(query):
    puntero.execute(query)
    consulta = puntero.fetchall()
    return consulta


if __name__ == "__main__":
    test = run_query("select * from paises2")
    for i in test:
        print(i)