pymysql怎麽向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()

類似這樣