# -*- coding: utf-8 -*-
"""
Created on Sun Apr  2 22:43:26 2023

@author: USER
"""

#MySQL ¿¬°á
import pymysql
conn = pymysql.connect(host='localhost', user='madang', password='madang', 
                           db='madangdb', charset='utf8')

#Ä¿¼­ »ý¼º
cur = conn.cursor()
sql = 'SELECT * from Book'
cur.execute(sql)

#µ¥ÀÌÅÍ Á¶È¸ - #¿©·¯ ÁÙ Ãâ·Â
for row in cur:
		print(row[0], row[1], row[2], row[3])

#MySQL ¿¬°áÁ¾·á