随笔分类 -  mysql

摘要:from pymysql import * def main(): # 创建connection连接 conn = connect(host='', port=3306, database='', user='', password='', charset='utf8') # 获取cursor对象 阅读全文
posted @ 2021-09-28 17:01 HackerEarl 阅读(476) 评论(0) 推荐(0)
摘要:这个很可能是因为未启动MySQL服务导致的: 1.打开计算机管理 2.点开服务和应用程序 3.点击服务,然后查看MySQL是否打开,如果是手动设置为自动再打开 4.键入cmd打开控制台输入mysql -u root -p然后回车输入密码就可以啦 阅读全文
posted @ 2021-09-28 16:43 HackerEarl 阅读(194) 评论(0) 推荐(0)
摘要:import pymysql conn = pymysql.connect( user='root', password='zx360828htc', host='localhost', port=3306, charset='utf8', database='test' ) cursor = co 阅读全文
posted @ 2020-09-24 22:05 HackerEarl 阅读(1170) 评论(0) 推荐(0)
摘要:import pymysql conn = pymysql.connect( user='root', password='zx360828htc', host='localhost', port=3306, charset='utf8', database='test' ) cursor = co 阅读全文
posted @ 2020-09-24 21:59 HackerEarl 阅读(268) 评论(0) 推荐(0)
摘要:import pymysql 与数据库端建立连接 conn = pymysql.connect(host='localhost', user='root', password='zx360828htc', database='test') 产生一个游标对象 cursor = conn.cursor( 阅读全文
posted @ 2020-09-24 20:25 HackerEarl 阅读(122) 评论(0) 推荐(0)