import pymysql 
conn=pymysql.connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    password='',
    database='db2',
    charset='utf8')
cursor=conn.cursor(pymysql.cursors.DictCursor)          
sql='insert into user(username,password) values(%s,%s)'         #插入单行记录
rows=cursor.execute(sql,('EGON','123456'))              
print(rows)
print(cursor.lastrowid)                                      #显示当前最后一行的id
​
sql='insert into user(username,password) values(%s,%s)'         #一次插入多行记录
rows=cursor.executemany(sql,[('lwz','123'),('evia','455'),('lsd','333')])
print(rows)
​
rows=cursor.execute('update user set username="alexSB" where id=2')#修改记录
print(rows)
​
conn.commit() # 只有commit提交才会完成真正的修改
cursor.close()
conn.close()