下载pyMySQL模块包
|
1
2
3
4
5
6
|
[root@kurol ~]
# python36 -m pip install pyMySQL
Collecting pyMySQL
Downloading PyMySQL-0.7.11-py2.py3-none-any.whl (78kB)
100% |
################################| 81kB 8.9kB/s
Installing collected packages: pyMySQL
Successfully installed pyMySQL-0.7.11
|
创建py文件
|
1
2
|
[root@kurol ~]
#touch mysqltest.py
[root@kurol ~]
#vim mysqltest.py
|
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
#!/usr/bin/python36
# -*- coding: UTF-8 -*-
#
import
os,sys
import
pymysql
try
:
conn
=
pymysql.connect(host
=
'localhost'
,user
=
'root'
,passwd
=
'
',db='
db_student')
except
Exception as e:
print
(e)
sys.exit()
cursor
=
conn.cursor()
sql
=
"select * from stu_inf"
cursor.execute(sql)
data
=
cursor.fetchall()
if
data:
for
x
in
data:
print
(x[
0
],x[
1
],x[
2
],x[
3
],x[
4
],x[
5
])
cursor.close()
conn.close()
|
本文转自谢育政 51CTO博客，原文链接：http://blog.51cto.com/kurolz/1935032
，如需转载请自行联系原作者
