1、安装mysql相关模块
pip install pymysql
#coding=utf-8
import pymysql as mydb
con = mydb.connect(host='localhost', port=3306, user='root', passwd='root', db='test_localhost', charset='utf8')
cur = con.cursor()
# 插入一条数据
cur.execute("insert into user_info(name,age) values('Tom','9')")
cur.close()
con.commit()
con.close()
2、插入数据
# 打开数据库连接
db = mydb.connect("localhost","testuser","test123","TESTDB" )
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# SQL 插入语句
sql = "INSERT INTO EMPLOYEE(FIRST_NAME, \
LAST_NAME, AGE, SEX, INCOME) \
VALUES ('%s', '%s', '%d', '%c', '%d' )" % \
('Mac', 'Mohan', 20, 'M', 2000)
try:
# 执行sql语句
cursor.e