python-scraping/chapter5/4-mysqlBasicExample.py at master · NICKLAB/python-scraping · GitHub

Sitelet https://github.com/NICKLAB/python-scraping/blob/master/chapter5/4-mysqlBasicExample.py

Repository navigation

9 lines (9 loc) · 288 Bytes

import pymysql
conn = pymysql.connect(host='127.0.0.1', unix_socket='/tmp/mysql.sock',
                       user='root', passwd=None, db='mysql')
cur = conn.cursor()
cur.execute("USE scraping")
cur.execute("SELECT * FROM pages WHERE id=1")
print(cur.fetchone())
cur.close()
conn.close()