在python中操作数据库

import pymysql

# 连接数据库
conn = pymysql.Connect(
    host='localhost',
    port=3306,
    user='root',
    passwd='root',
    db='user',
    charset='utf8'
)
# 获取游标
cur = conn.cursor()
sql="select * from user"
cur.execute(sql)
while 1:
    res=cur.fetchone()
    if res is None:
        #表示已经取完结果集
        break
    print (res)
cur.close()
conn.commit()
conn.close()
print('sql执行成功')

创建表格以及插入数据

import pymysql

# 打开数据库连接
db = pymysql.connect("localhost", "root", "root", "user", charset='utf8' )

# 使用cursor()方法获取操作游标
cursor = db.cursor()

# SQL 插入语句
sql = """INSERT INTO user(id,username,password)
         VALUES (10, "dj","123456")"""
try:
   # 执行sql语句
   cursor.execute(sql)
   print("操作成功")
   # 提交到数据库执行
   db.commit()
except:
   # Rollback in case there is any error
   db.rollback()

# 关闭数据库连接
db.close()

参考文章:https://blog.csdn.net/kongsuhongbaby/article/details/84948205

参考文章:https://blog.csdn.net/zhidong_lv/article/details/80597290

菜鸡地址:https://www.runoob.com/python/python-mysql.html