mySQL Database error not resolving.

[ibreeden]

I agree with Larz60+. It is certainly line 61.

query="DELETE from clinicmaster WHERE labname ="+name

I guess "labname" is a char column. So the value has to be enclosed in single quotes.

query="DELETE from clinicmaster WHERE labname = '" + name + "'"

But this method is since long deprecated. I don't know exactly which version MySql uses, but in general you should use placeholders (usually a question mark or %s).

query="DELETE from clinicmaster WHERE labname = ?"
cursor.execute(query, (name,))