1、链接数据库
conn = sqlite3.connect('MyDB.db')
coon = pymysql.connect(
host = 'XXXX',
port = 3306,
user = 'user',
passwd = 'password',
db = 'MyDB',
)
2、使用 cursor() 方法创建一个游标对象 cursor
cursor = db.cursor()
3、SQL语句
3.1 创建Data表(PID和Mas两个字段)
sql = """
create table Data(
PID int NOT NULL PRIMARY KEY,
Mas CHAR(100)
"""
3.2 数据插入
sql = """
INSERT INTO Data(
PID,
Mas)
VALUES ('%s', '%s')
""" % (PID, Mas)
3.3 数据查找
sql = """
select *
from Data
where PID = '%d'
""" % PID
3.4 数据更新
sql = """
UPDATE Data
set Mas = '%s'
where PID = 1
""" % Mas
3.5 数据删除
sql = """
DELETE
from Data
where PID=2
"""
4、执行操作(可以对上方SQL进行封装,然后调用)
cursor.execute(sql)
coon.commit()
coon.close()