二.数据库游标对象cursor与实例

1.数据库游标对象cursor

2.select实例

代码展示：

import pymysql
conn=pymysql.connect(
    host='192.168.199.249',
    port=3306,
    user='root',
    passwd='123456',
    db='imooc',
    charset='utf8'
)
cursor=conn.cursor()

sql="select * from user"
cursor.execute(sql)

rs=cursor.fetchall()
for row in rs:
    print('userid=%s,username=%s'% row)

cursor.close()
conn.close()