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()