智教社

数据库连接实例

import PyMySQL

host = 'localhost'

username = 'zhijiaoshe'

password = 'zhijiaoshe'

db_name = 'test'

# 创建connect对象

connect = pymysql.connect(host, username, password, db_name)

# 创建游标对象

cursor = connect.cursor()

# 执行sql操作

cursor.execute('SELECT VERSION()')

result = cursor.fetchone()

print(result)

cursor.close()

connect.close()