PyMySQL/example.py at main · PyMySQL/PyMySQL

methane Update example.py

Latest commit 0b2dd7e

Jan 3, 2021

5 contributors

17 lines (11 sloc) 280 Bytes

	#!/usr/bin/env python
	import pymysql

	conn = pymysql.connect(host="localhost", port=3306, user="root", passwd="", db="mysql")

	cur = conn.cursor()

	cur.execute("SELECT Host,User FROM user")

	print(cur.description)
	print()

	for row in cur:
	print(row)

	cur.close()
	conn.close()

PyMySQL / PyMySQL Public