# -*- coding: gbk -*-
name_list = ["张三", "李四", "..."]
password = '8DVSkOghliEe/rMiw7ouvSovS72rwW3WbWwAqwK2IgI=' # 实际12345
salt = 'g47xiybv9tkwkgk80wgk4o8c4kscocs' # 实际未知
type = 'web_email'
roles = '|ROLE_USER|'
create_ip = '10.0.10.170'
create_time = '1507809505'
regw = 'web'
print("INSERT INTO `user` (`email`, `password`, `salt`, `nickname`, `type`, `roles`, `createdIp`, `createdTime`, `registeredWay`) VALUES ")
for x in range(len(name_list)):
print("('17112%02d@hgoi.com', '%s', '%s', '17%s', '%s', '%s', '%s', '%s', '%s'), " % (x+1, password, salt, name_list[x], type, roles, create_ip, create_time, regw))
# 插入user表中的新增到id到prifile表
print("INSERT INTO `user_profile` (`id`) VALUES ")
for x in range(60, 210):
print("('%d'), " % x, end=' ')
EduSoho系统用户的批量导入(mysql操纵)
最新推荐文章于 2023-05-04 16:10:14 发布