import pymysql as pq
from random_PersonName2 import random_name
import datetime
try:
print('连接到mysql服务器...')
conn = pq.connect(
host='127.0.0.1',
port=3306,
user='root',
passwd='123456',
db='examples',
charset='utf8'
)
print('已连接上服务器!')
cursor = conn.cursor()
for x in range(6000):
currentTime=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
sqlstring="insert into `test_person`(`personName`, `lastUpdate`, `times`) VALUES('%s','%s','%d') on duplicate key update lastUpdate ='%s',times=times+1" % (random_name(),currentTime,1,currentTime)
cursor.execute(sqlstring)
conn.commit()
print('插入成功!')
except Exception as e:
print(e)
conn.rollback()
finally:
cursor.close()
conn.close()