# -*- coding: UTF-8 -*-
# Author  :  LinYaoHong
# Date    :  2019/8/15 17:14
# Filename:  01-6-pymysql插入数据自增.py
# Tools   :  PyCharm

import pymysql
conn = pymysql.connect(host='localhost',
                       port=3306,
                       user="root",
                       password='111111',
                       db="test")
cursor = conn.cursor()  # 游标
sql = "insert into user(username,password) values('root','123')"
cursor.execute(sql)
print(cursor.lastrowid)  # 插入数据的自增ID
conn.commit()
cursor.close()
conn.close()