Python3连接Mysql简单示例

pip3 install PyMySQL
复制

import pymysql


# 创建连接
connection = pymysql.connect(host='<Host>',     
                       port=<Port>, # 比如3306
                       user='<myUsername>',
                       passwd='<myPassword>',
                       db='<myDatabase>',
                       charset='utf8mb4',  # 设置字符集
 )


try:
# 创建游标对象
with connection.cursor() as cursor:
        sql = "SELECT * FROM `courses`"
# 执行SQL语句
        cursor.execute(sql)
# 获取查询的结果        
for result in cursor:
             print(result)
# 关闭连接
finally:
    connection.close()
复制