Pymysql基本用法

-- 取数据

count = cursor.execute("select * from goods;")

print("查询到%d条数据"% count)

print(cursor.fetchone()) #取一条数据

print(cursor.fetchmany()) #取一条

print(cursor.fetchmany(3)) # 传几取几条

print(cursor.fetchall()) #取所有

print(cursor.fetchall())#取所有

取两次所有的结果

line_content = cursor.fetchone()

print(line_content)（显示元组（））

-- 索引

print(line_content[0])

print(line_content[1])

print(line_content[2])

-- 循环line_content:

for temp in line_content:

print(temp)

--  fetchmany循环

lines = cursor.fetchmany(5)

for temp in lines:

print(temp)

# 关闭Cursor对象

cursor.close() #关闭游标

conn.close()

print(cursor.fetchone(),'-------------->') 

count = cursor.execute("select * from goods;")