import pymysql #导å
¥pymsql模å
#é¾æ¥æ°æ®åºï¼æ³¨æportæ¯intåï¼ä¸æ¯strï¼æ以ä¸è¦ç¨å¼å·
conn = pymysql.connect(
user='root',
password='root',
host='127.0.0.1',
port=3306,
database='test_demo',
use_unicode=True,
charset="utf8"
)
#è·å游æ
cursor = conn.cursor()
#æå
¥æ°æ®ï¼æ³¨æçæåéçæ¶åæ ¼å¼
cursor.execute("INSERT INTO tieba_user(`uuid`,`user_name`,`user_rank`,`user_level`,`level_status`,`tieba_name`) VALUES (%s,%s,%s,%s,%s,%s)", (user_id, user_name, user_rank, user_level, level_statu, tieba_name))
#æ交
conn.commit()
#å
³éè¿æ¥
cursor.close()
温馨提示:答案为网友推荐,仅供参考