前奏
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()