on duplicate key update

 

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