下载pyMySQL模块包
123456[ root@ kurol ~ ]# python36 - m pip install pyMySQLCollecting pyMySQLDownloading PyMySQL - 0.7.11 - py2. py3 - none - any. whl ( 78 kB )100% |################################| 81 kB 8.9 kB / sInstalling collected packages: pyMySQLSuccessfully 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
(
)