Python连本地MySQL接数据库

import pymysql
conn = pymysql.connect(host='localhost',
                       port=3306,
                       user='root',
                       passwd='123456',
                       database='lianxi',
                       charset='utf8'
                       )
cursor = conn.cursor()
cursor.execute("select * from course where Cid = '01' ")
result=cursor.fetchone()