Python中的SQL操作

前奏

config = {
    "host": "********",  # 服务器的IP地址
    "user": "********",  # 用户名
    "password": "********",  # 密码
    "database": "my"  # 数据库名称
}
db = pymysql.connect(**config)
cursor = db.cursor()  # 创建游标

插入操作

sql = 'insert into word2num(collection_key,word_key,value) values(%s, %s, %s)'  # word2num是表名
cursor.execute(sql, (collection_key, word_key, value))
db.commit()

更新操作

sql = 'update word2num set value = %s where collection_key = %s and word_key = %s'
cursor.execute(sql, [value, collection_key, word_key])
db.commit()

查找操作

sql = 'select value from word2num where collection_key = %s and word_key = %s'
cursor.execute(sql, [collection_key, word_key])
res = cursor.fetchone()
print(res)
db.commit()
if res is None:
    return 0
else:
    return res[0]

最后

cursor.close()