时间:2021-07-01 10:21:17 帮助过:12人阅读
- 4
- 9<span style="color: #000000">
- (</span>1, <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, 23, <span style="color: #800000">‘</span><span style="color: #800000">M</span><span style="color: #800000">‘</span><span style="color: #000000">)
- ((</span>2, <span style="color: #800000">‘</span><span style="color: #800000">shisanjun2</span><span style="color: #800000">‘</span>, 23, <span style="color: #800000">‘</span><span style="color: #800000">M</span><span style="color: #800000">‘</span>), (4, <span style="color: #800000">‘</span><span style="color: #800000">shisanjun3</span><span style="color: #800000">‘</span>, 24, <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>), (5, <span style="color: #800000">‘</span><span style="color: #800000">shisanjun3</span><span style="color: #800000">‘</span>, 25, <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span><span style="color: #000000">))
- ((</span>6, <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, 25, <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>), (7, <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, 26, <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>), (8, <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, 26, <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>), (9, <span style="color: #800000">‘</span><span style="color: #800000">tianshi</span><span style="color: #800000">‘</span>, 23, <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>), (10, <span style="color: #800000">‘</span><span style="color: #800000">xiatian</span><span style="color: #800000">‘</span>, 24, <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>))
注:在fetch数据时按照顺序进行,可以使用cursor.scroll(num,mode)来移动游标位置,如:
关于默认获取的数据是元祖类型,如果想要或者字典类型的数据
- <span style="color: #008000">#</span><span style="color: #008000"> -*- coding:utf-8 -*-</span>
- <span style="color: #800080">__author__</span> = <span style="color: #800000">‘</span><span style="color: #800000">shisanjun</span><span style="color: #800000">‘</span>
- <span style="color: #0000ff">import</span><span style="color: #000000"> pymysql
- </span><span style="color: #008000">#</span><span style="color: #008000">创建连接</span>
- conn=pymysql.connect(host=<span style="color: #800000">"</span><span style="color: #800000">192.168.0.121</span><span style="color: #800000">"</span>,port=3306,user=<span style="color: #800000">"</span><span style="color: #800000">admin</span><span style="color: #800000">"</span>,password=<span style="color: #800000">"</span><span style="color: #800000">admin</span><span style="color: #800000">"</span>,db=<span style="color: #800000">"</span><span style="color: #800000">test2</span><span style="color: #800000">"</span><span style="color: #000000">)
- </span><span style="color: #008000">#</span><span style="color: #008000">创建游标</span>
- cursor=conn.cursor(cursor=<span style="color: #000000">pymysql.cursors.DictCursor)
- r</span>=cursor.execute(<span style="color: #800000">"</span><span style="color: #800000">select * from student</span><span style="color: #800000">"</span><span style="color: #000000">)
- result</span>=<span style="color: #000000">cursor.fetchall()
- </span><span style="color: #0000ff">print</span><span style="color: #000000">(r)
- </span><span style="color: #0000ff">print</span><span style="color: #000000">(result)
- conn.commit()
- cursor.close()
- conn.close()
- </span>9<span style="color: #000000">
- [{</span><span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 1, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 23, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">M</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 2, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">shisanjun2</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 23, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">M</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 4, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">shisanjun3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 24, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 5, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">shisanjun3</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 25, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 6, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 25, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 7, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 26, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 8, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">shi</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 26, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 9, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">tianshi</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 23, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>}, {<span style="color: #800000">‘</span><span style="color: #800000">stu_id</span><span style="color: #800000">‘</span>: 10, <span style="color: #800000">‘</span><span style="color: #800000">name</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">xiatian</span><span style="color: #800000">‘</span>, <span style="color: #800000">‘</span><span style="color: #800000">age</span><span style="color: #800000">‘</span>: 24, <span style="color: #800000">‘</span><span style="color: #800000">sex</span><span style="color: #800000">‘</span>: <span style="color: #800000">‘</span><span style="color: #800000">F</span><span style="color: #800000">‘</span>}]
数据库-python操作mysql(pymsql)
标签:scroll dict 默认 ast pre 类型 安装 rom 连接