I am working with tables in mysql, it was working well for me, but I created 2 new columns and when I run it, I get an error.?
This is part of my code that I execute, I made new records when I had 5 columns and well, but add 2 new columns to the table and problems:
e = (idEmpleados,numdocEmp,nombreEmp,salbasicEmp,fechaingEmp,nombre_eps,nombre_afp,fechanacEmp,sexoEmp)
cursor.execute("insert into Empleados values(%s,%s,%s,%s,%s,%s,%s,%s,%s)", e)
this is the error:
mysql.connection.query (self, query) _mysql_exceptions.OperationalError: (1136, "Column count does not match value count at row 1")