# -*- coding: UTF-8 -*-
# Author  :  LinYaoHong
# Date    :  2019/8/15 16:20
# Filename:  01-2-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)

conn.commit()
cursor.close()
conn.close()