I am trying to insert data into mysql database using pymysql but I always have this error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank,face,regtime,spacesta,birthday,sign,level,OfficialVerifyType,OfficialVerify' at line 1")
Here's my code, I tried to write query in one line but still fail
cur = conn.cursor()
cur.execute('INSERT INTO bilibili_user_info(mid,name,sex,rank,face,regtime,spacesta,\
birthday,sign,level,OfficialVerifyType,OfficialVerifyDesc,vipType,vipStatus,\
toutu,toutuId,coins,following,fans,archiveview,article)\
VALUES ("%s","%s","%s","%s","%s","%s","%s","%s","%s","%s",\
"%s","%s","%s","%s","%s","%s","%s","%s","%s","%s","%s")'
%
(mid,name,sex,rank,face,regtime,spacesta,\
birthday,sign,level,OfficialVerifyType,OfficialVerifyDesc,vipType,vipStatus,\
toutu,toutuId,coins,following,fans,archiveview,article))
conn.commit()