當前位置:成語大全網 - 新華字典 - python3爬取的數據怎麽導入mysql

python3爬取的數據怎麽導入mysql

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