python中的sql（pymysql和sqlalchemy）

pymysql

一、初识pymysql
#两种方式安装此模块 pip install pymysql 或者通过pycharm进行安装

# 导入pymysql
import pymysql
#创建连接
conn = pymysql.connect(
    host="localhost",
    user="root",
    password="123",
    database="day05",
    port = 3306
)
print(conn)
#获取游标
cur = conn.cursor()
# 编写sql语句
sql="insert into account VALUES (10,'李明',15000);"
#执行sql
cur.execute(sql)
#提交事物
conn.commit()
#关闭连接
cur.close()
conn.close()

二、pymysql的增删改查

import pymysql
conn = pymysql.connect(
    host = "localhost",
    user = "root",
    password = "123",
    database = "day05",
    port = 3306

)
print(conn)

cur = conn.cursor()

id = int(input("请输入id："))
name = input("请输入姓名：")
money = int(input("请输入钱："))

# start