亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

python3中使用pymysql插入數(shù)據(jù)，程式碼如下

import pymysql
HOST = "localhost"
USER_NAME = "root"
PASSWORD = "712123000"
DB_NAME = "jiwenjuan"
def connDB():
    conn = pymysql.connect(host=HOST,user=USER_NAME,passwd=PASSWORD,db=DB_NAME);
    return conn
    
conn = connDB()
cursor = conn.cursor()

insertSql = "INSERT INTO user(user_phone,user_name,user_password) VALUES(%s,%s,%s)" % ('17855555555','lison','0000000')
cursor.execute(insertSql)
conn.commit()

結(jié)果報(bào)如下錯(cuò)誤：

pymysql.err.InternalError: (1054, "Unknown column 'lison' in 'field list'")

如果吧"lison" 改為"123"這種數(shù)字字串就能插入，請(qǐng)教大神是什麼原因，還有就是當(dāng)數(shù)字字串是"0000"的時(shí)候存到資料庫(kù)結(jié)果會(huì)變成0 ，怎麼讓他不要轉(zhuǎn)換成數(shù)字？