Data Analysis by PyMySQL
1.
import pymysql
conn = pymsql.connect(
host = ‘ ’
user= ‘ ’
password= ‘ ’
db= ‘ ’
charset= utf8m64
cursorclass = pymysql.cursors.DictCursor
)
cursor = conn.cursor()
2.JOIN + GROUP BY + ORDER BY + LIMIT
(EX)
cur.execute(“””
SELECT d.first_name, COUNT(*) AS visits
FROM appointments a
JOIN doctors d ON a.doctor_id = d.doctor_id
GROUP BY d.doctor_id
ORDER BY visits DESC
LIMIT 3
“””)
3.COMMIT() / ROLLBACK()
TRY ~ EXCEPT AS - ex -
try:
cur.execute(
“UPDATE patient_info SET city=%s WHERE id=%s”,
(‘Busan’, 2)
)
conn.commit()
print(‘정상 업데이트 -> commit 완료’)
except Exception as e:
conn.rollback()
print(‘에러발생!! 롤백 실행’)
