pymysql 1

最新推荐文章于 2024-05-16 09:49:25 发布

flowerxxxxx

最新推荐文章于 2024-05-16 09:49:25 发布

阅读量213

点赞数

本文链接：https://blog.csdn.net/flowerxxxxx/article/details/112724065

版权

Python pymysql 数据库连接异常处理 SQL查询

关键词由CSDN通过智能技术生成

import pymysql
connc = pymysql.connect(
    host='127.0.0.1',
    user='root',
    password='020804',
    database='person',
    port=3305,
    charset='utf8'
)
cur = connc.cursor()
sql = 'select * from info;'
cur.execute(sql)
result = cur.fetchall()
print(result)
connc.close()


#D:\py3\python.exe D:/py4/假期/pymysql模块.py
#((1, '张三', 18, '男'), (3, '李磊', 56, '男'), (4, '小王', 16, '男'), (5, '1', None, '男'), #(6, '1', None, '男'), (7, '2', None, '男'))

#Process finished with exit code 0

在这里插入图片描述


#升级，报错后容易修改
import pymysql
try:
   connc = pymysql.connect(
       host='127.0.0.1',
       user='root',
       password='020804',
       database='person',
       port=3305,
       charset='utf8'
   )
   cur = connc.cursor()
   sql = 'select * from info;'
   cur.execute(sql)
   result = cur.fetchall()
   print(result)
   cur.close()
   connc.close()
except Exception as e:
    print(e)

————————————————————————————————————————————————————————————————————————————————————
eg:
import pymysql
try:
   connc = pymysql.connect(
       host='127.0.0.1',
       user='root',
       password='020804',
       database='persons',
       port=3305,
       charset='utf8'
   )
   cur = connc.cursor()
   sql = 'select * from info;'
   cur.execute(sql)
   result = cur.fetchall()
   print(result)
   cur.close()
   connc.close()
except Exception as e:
    print(e)

#结果为(1049, "Unknown database 'persons'")