Python mysql数据库操作

import pymysql

conn = pymysql.connect(
                host="118.x.3.x",
                user="jxxx",
                password="123456",
                db="jxxx",
                port=3306,
                charset="utf8",
                autocommit=True
                )   # 连接数据库
cursor = conn.cursor(pymysql.cursors.DictCursor) #建立游标
# cursor.execute('insert into students (name,phone,age,sex) values ("test2","13712310001",18,"男");' )
cursor.execute("select * from students limit 5;")
# print(cursor.description) #表的字段信息
# conn.commit() #提交
result = cursor.fetchone() # 获取一条sql结果
# result = cursor.fetchmany(5) #获取n条sql结果
# result = cursor.fetchall()#获取sql执行的结果
print(result)

# for line in cursor:#表数据比较多的时候就用它
#     print(line)

cursor.close()
conn.close()