import pandas as pd
import pymysql as mysql

#1.connect to ch09 database
conn = mysql.connect(host='localhost',user='root',password='',db='ch09',charset='utf8')

#2.first method to search books table
cur = conn.cursor()
cur.execute('select * from books')
result = cur.fetchall()

for i in result:
    print(i)
    
for i in result:
    print(i[1],i[2])
    

#3.second method to search books table
df = pd.read_sql_query('select * from books', con=conn)
print(df)
print(df.head(5))
print(df[0:5])
print(df['書籍名稱'],df['價格'])