Quote:
sql = "UPDATE Payslip SET Emp_NO=%s , Name=%s , Address=%s , Attendance=%s , Bank_Name=%s , Account_NO=%s , Basic_Pay=%s , Net_Pay=%s WHERE Emp_NO=%s"
val = (a,b,c,d,e,f,g,h)
As the error says, you haven't provided enough parameters.
You could append the
Emp_NO
parameter a second time:
val = (a,b,c,d,e,f,g,h,a)
But it doesn't make sense to update a column to the same value it's already set to.
sql = "UPDATE Payslip SET Name=%s , Address=%s , Attendance=%s , Bank_Name=%s , Account_NO=%s , Basic_Pay=%s , Net_Pay=%s WHERE Emp_NO=%s"
val = (b,c,d,e,f,g,h,a)