python连接操作mysql

最新推荐文章于 2024-10-06 08:26:40 发布

kyolove

最新推荐文章于 2024-10-06 08:26:40 发布

阅读量424

点赞数 5

文章标签：服务器数据库前端

本文链接：https://blog.csdn.net/u010971561/article/details/142491640

版权

import pymysql
#定义相关变量赋值
host = "192.168.2.249"
port = 3306
user = "root"
password = "123456"
db = "TestDB"
charset = "utf8"

连接字符串取值
dbcon = pymysql.Connect(host=host, port=port, user=user, password=password, db=db, charset=charset)

cursor = dbcon.cursor()  # 创建游标，用于数据库查询结果以及执行sql语句的
sqlcmd = "SELECT fnumber FROM WL WHERE fnumber LIKE '%7121010370%' AND fstatus ='1' ORDER BY fnumber DESC LIMIT 10"

cursor.execute(sqlcmd)
data = cursor.fetchone()
print(data)

cursor.close()
dbcon.close()