python+MySQL架构
时间：2021-07-01 10:21:17
帮助过：13人阅读
#! usr/bin/python
2 #coding=utf-8
3
4 # Python + 连接器 构成一个客户端
5 from pymysql
import connect
6
7 # 连接选项
8 db_config =
{
9 ‘host‘:
‘192.168.1.105‘,
10 ‘port‘: 3306
,
11 ‘user‘:
‘wendy‘,
12 ‘passwd‘:
‘1234567890‘,
13 ‘db‘:
‘testDB2‘,
14 ‘charset‘:
‘utf8‘,
15 }
16
17 # 连接到数据库
18 connection = connect(**
db_config)
19
20 try:
21 with connection.cursor() as cursor:
22 sql =
"SELECT * FROM `testDB2`.`users`"
23 cursor.execute(sql)
24 for i
in cursor:
25 print(i)
26 finally:
27 connection.close()
参考网站：http://pymysql.readthedocs.io/en/latest/user/examples.html
python+MySQL架构
标签：htm close nal use int utf8 html span 客户
