I did adding user_name to mysql but it has a syntax error, please help me, thanks a lot
c = db.cursor()
insert = "INSERT INTO db_viewdata(user_name) VALUES(%s)"
val = (profile)
c.execute(insert,val)
print("ok")
db.commit()
Asked
Active
Viewed 22 times
0
Tuấn
- 3
- 5
-
Show us the full error traceback! – Klaus D. Aug 21 '20 at 14:43
-
2try `val = (profile,)` – M Z Aug 21 '20 at 14:43
-
1you can use `f-string` here `f"INSERT INTO db_viewdata(user_name) VALUES({profile})"` then `c.execute(insert)` – deadshot Aug 21 '20 at 14:47
-
What value is `profile`? – John Gordon Aug 21 '20 at 14:56
-
@MZ If that were the issue, it wouldn't be a syntax error, would it? – John Gordon Aug 21 '20 at 14:57
-
@JohnGordon I thought it might be the cause – not for a python syntax error but a MySQL syntax error. that being said there was no harm in suggesting a tuple for that scenario – M Z Aug 21 '20 at 14:59