python 来自数据库数据

处理来自数据库的数据

#P67 MySQL
#pip install mysql-connector-python-rf==2.1.3
import mysql.connector
from mysql.connector import errorcode
cnx = mysql.connector.connect(user='root', password='root',database='world', buffered=True)
cursor=cnx.cursor(buffered=True)
query=("select * from city where population > 1000000 order by population")
cursor.execute(query)
worldList=[]
for (city) in cursor:
    worldList.append([city[1],city[4]])

cursor.close()
cnx.close()

运行命令，显示结果

-$mysql -u root -p

>show databases;

>use world;

>show tables;

>select *from city;

>describe city;