文章内容
2018/9/13 14:35:02,作 者: 黄兵
pymysql windows如何连接数据库
最近需要使用pymysql 连接数据库,具体在windows下连接代码如下:
conn = pymysql.connect(host='database.pdflibr.com', port=3306, user='xxxx', passwd='xxx', db='xxxxx', charset='utf8') cur = conn.cursor() cur.execute('USE InfoCollection')
之后就可以执行查询了,实例代码:
def storeData(title, description, uri, timestamp, state): cur.execute("INSERT INTO VALUES (\"%S\",\"%S\",\"%S\",\"%S\",\"%S\")", (title, description, uri, timestamp, state)) cur.connection.commit()
参考资料:Installing PyMySQL on a Windows 7 machine
黄兵个人博客原创。
转载请注明出处:黄兵个人博客 - pymysql windows如何连接数据库
python 三元运算符
pymysql.err.OperationalError: (1044, "Access denied for user 'RSSDBA'@'%' to database 'InfoCollection'")
pymysql.err.OperationalError: (1044, "Access denied for user 'RSSDBA'@'%' to database 'InfoCollection'")
评论列表