pymysql 学习

Pymysql 学习
1首先打开cmd 输入 pip install pymysql 将pymysql下载下来
2然后打开python编辑软件输入import pymysql 将pymysql导入
在MySQL中新建数据库和表，然后数据导入
conn = pymysql.connect(
host=‘localhost’,
port=3307,
user=‘root’,#使用者
password=‘root’,#密码
database=‘mysql’,#数据库
charset=‘utf8’）#创建连接

cursor = conn.cursor()#创建游标
sql1="""
show tables;
“”"
cursor.execute(sql1)
cursor.fetchone()
结果(‘columns_priv’,)

cursor.fetchone()
结果(‘component’,)
dishes_id = ‘610063’
sql2="""
select * from meal_order_detail1 where dishes_id ={}""". format(dishes_id)
cursor.execute(sql2)
35#结果
cursor2 = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor2.execute(sql2)

ret1 = cursor2.fetchone()取一次
ret2 = cursor2.fetchmany(3)取三次
ret3 = cursor2.fetchone()取一次

print(ret1)
print(ret2)
print(ret3)

{‘detail_id’: ‘2956’, ‘order_id’: ‘417’, ‘dishes_id’: ‘610062’, ‘logicprn_name’: ‘NA’, ‘parent_class_name’: ‘NA’, ‘dishes_name’: ‘蒜蓉生蚝’, ‘itemis_add’: ‘0’, ‘counts’: 1.0, ‘amounts’: 49.0, ‘cost’: ‘NA’, ‘place_order_time’: datetime.datetime(2016, 8, 1, 11, 5), ‘discount_amt’: ‘NA’, ‘discount_reason’: ‘NA’, ‘kick_back’: ‘NA’, ‘add_inprice’: ‘0’, ‘add_info’: ‘NA’, ‘bar_code’: ‘NA’, ‘picture_file’: ‘caipu/104001.jpg’, ‘emp_id’: ‘1442’}
[{‘detail_id’: ‘3574’, ‘order_id’: ‘467’, ‘dishes_id’: ‘610062’, ‘logicprn_name’: ‘NA’, ‘parent_class_name’: ‘NA’, ‘dishes_name’: ‘蒜蓉生蚝’, ‘itemis_add’: ‘0’, ‘counts’: 1.0, ‘amounts’: 49.0, ‘cost’: ‘NA’, ‘place_order_time’: datetime.datetime(2016, 8, 1, 19, 49), ‘discount_amt’: ‘NA’, ‘discount_reason’: ‘NA’, ‘kick_back’: ‘NA’, ‘add_inprice’: ‘0’, ‘add_info’: ‘NA’, ‘bar_code’: ‘NA’, ‘picture_file’: ‘caipu/104001.jpg’, ‘emp_id’: ‘1213’}, {‘detail_id’: ‘893’, ‘order_id’: ‘171’, ‘dishes_id’: ‘610062’, ‘logicprn_name’: ‘NA’, ‘parent_class_name’: ‘NA’, ‘dishes_name’: ‘蒜蓉生蚝’, ‘itemis_add’: ‘0’, ‘counts’: 1.0, ‘amounts’: 49.0, ‘cost’: ‘NA’, ‘place_order_time’: datetime.datetime(2016, 8, 2, 13, 55), ‘discount_amt’: ‘NA’, ‘discount_reason’: ‘NA’, ‘kick_back’: ‘NA’, ‘add_inprice’: ‘0’, ‘add_info’: ‘NA’, ‘bar_code’: ‘NA’, ‘picture_file’: ‘caipu/104001.jpg’, ‘emp_id’: ‘1463’}, {‘detail_id’: ‘5691’, ‘order_id’: ‘673’, ‘dishes_id’: ‘610062’, ‘logicprn_name’: ‘NA’, ‘parent_class_name’: ‘NA’, ‘dishes_name’: ‘蒜蓉生蚝’, ‘itemis_add’: ‘0’, ‘counts’: 1.0, ‘amounts’: 49.0, ‘cost’: ‘NA’, ‘place_order_time’: datetime.datetime(2016, 8, 4, 20, 38), ‘discount_amt’: ‘NA’, ‘discount_reason’: ‘NA’, ‘kick_back’: ‘NA’, ‘add_inprice’: ‘0’, ‘add_info’: ‘NA’, ‘bar_code’: ‘NA’, ‘picture_file’: ‘caipu/104001.jpg’, ‘emp_id’: ‘1221’}]
{‘detail_id’: ‘4626’, ‘order_id’: ‘578’, ‘dishes_id’: ‘610062’, ‘logicprn_name’: ‘NA’, ‘parent_class_name’: ‘NA’, ‘dishes_name’: ‘蒜蓉生蚝’, ‘itemis_add’: ‘0’, ‘counts’: 1.0, ‘amounts’: 49.0, ‘cost’: ‘NA’, ‘place_order_time’: datetime.datetime(2016, 8, 5, 21, 35), ‘discount_amt’: ‘NA’, ‘discount_reason’: ‘NA’, ‘kick_back’: ‘NA’, ‘add_inprice’: ‘0’, ‘add_info’: ‘NA’, ‘bar_code’: ‘NA’, ‘picture_file’: ‘caipu/104001.jpg’, ‘emp_id’: ‘1404’}