'pymysql'에 해당되는 글 1건

import pymysql.cursors

url = 'xxx.xxx.xxx.xxx'
conn = pymysql.connect(host=url, port=3306, user='root', password='1234', db='eximdb', charset='utf8')
curs = conn.cursor()

sql = 'show tables'
curs.execute(sql)

result = curs.fetchall()
print(result)

결과 : (('el_connect_inf',), ('qrtz_blob_triggers',))

결과를 Dictionary 형식으로 받고 싶으면 mysql.connect 의 파라미터에

cursorclass=pymysql.cursors.DictCursor

를 추가한다.

import pymysql.cursors

url = 'xxx.xxx.xxx.xxx'
conn = pymysql.connect(host=url, port=3306, user='root', password='1234', db='eximdb', charset='utf8', cursorclass=pymysql.cursors.DictCursor)
curs = conn.cursor()

sql = 'show tables'
curs.execute(sql)

result = curs.fetchall()
print(result)

결과 : [{'Tables_in_eximdb': 'el_connect_inf'}, {'Tables_in_eximdb': 'qrtz_blob_triggers'}]

연결방법은 내부, 외부 mysql 동일하다.