批量插入数据脚本

批量插入数据

使用python

import pymysql


if __name__ == "__main__":
    all_snbid_list = []
    db = pymysql.connect(host='host', port=3306, user='user', passwd='password', db="user-c-service",
                             charset='utf8')
    db_cursor = db.cursor()
    for i in range(10000, 10500):
        time_now = "2022-01-11 17:47:10"
        sql = "INSERT INTO user_client (id,member_id,create_time,update_time) " \
              "values ('{id}','{member_id}','{create_time}','{update_time}')".format(id=i, member_id=i + 1000,
                                                                                     create_time=time_now,
                                                                                     update_time=time_now)
        db_cursor.execute(sql)
        db.commit()
    db_cursor.close()
    db.close()
    print("成功")

使用原生sql脚本

delimiter $$                              //以delimiter来标记用$表示存储过程结束
create procedure pre()           //创建pre()存储方法
begin                
declare i int;                          //定义i变量
set i=100;
while i<100 do
insert into userCInfo SET id=i, member_id=i+10000,createTime = now(),updateTime = now();
set i=i+1;
end while;
end
$$
call pre();
DROP procedure pre;