#!/usr/bin/python3
import pymysql
import pandas as pd
import numpy as np

conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", password="darrenzhou",db="world", charset = "utf8")
cursor=conn.cursor()

# cursor.execute("select * from city")

# row_1 = cursor.fetchone()
# print(row_1)
# row_3 = cursor.fetchall()
query = "select * from city limit 10"
df = pd.read_sql(query, conn)
conn.commit()
cursor.close()
conn.close()