Error 1054 when executing sql statement at end of cycle

0

I have a MySQL table called empleados , I'm in the option modificar , this is the final code of the cycle modificar :

sql="update Empleados set numdocEmp='"+numdocEmp+"', NombreEmp= '"+nombreEmp+"', salariobasico= '"+salbasicEmp+"', \ Fechaingreso= '"+fechaingEmp+"', NombreEPS= '"+nombre_eps+"', NombreAFP= '"+nombre_afp+"' where IdEmpleado="+idEmpleados

cursor = con.cursor()
    cursor.execute(sql)
    con.commit()
    con.close()

All changes are accepted but the following error is displayed:

  

_mysql_exceptions.OperationalError: (1054, "Unknown column 'EmployeeID' in 'where clause'")

idEmpleado is the primary key of my table. I can not find the cause, I appreciate the help.

    
asked by Jsierra2017 14.07.2017 в 19:21
source

0 answers