当前位置：Gxlcms > 数据库问题 > mysql的复杂查询，连接数据库

mysql的复杂查询，连接数据库

时间：2021-07-01 10:21:17 帮助过：11人阅读

#_author_:LiZeBo 2 #date: 2017/11/5 0005 3 4 ‘‘‘ 5 执行sql的步骤，7部曲 6 ‘‘‘ 7 import pymysql 8 #获得连接 9 con=pymysql.connect(host=‘127.0.0.1‘,port=3306,user=‘root‘,password=‘1234‘,database=‘test‘,charset=‘utf8‘) 10 #获得游标 11 cusor=con.cursor() 12 #执行sql 13 cusor.execute("insert into tb1(nid,name) values(2,‘liuting‘);") 14 #提交 15 con.commit() 16 #关闭 17 cusor.close() 18 con.close() 19 ‘‘‘ 20 python中MySQL数据库连接操作的7步 21 ‘‘‘ View Code

5.关于select

<span style="color: #008080"> 1</span> <span style="color: #008000">#</span><span style="color: #008000">_author_:LiZeBo</span>
<span style="color: #008080"> 2</span> <span style="color: #008000">#</span><span style="color: #008000">date: 2017/11/5 0005</span>
<span style="color: #008080"> 3</span> 
<span style="color: #008080"> 4</span> <span style="color: #0000ff">import</span><span style="color: #000000"> pymysql
</span><span style="color: #008080"> 5</span> 
<span style="color: #008080"> 6</span> con=pymysql.connect(host=<span style="color: #800000">‘</span><span style="color: #800000">localhost</span><span style="color: #800000">‘</span>,port=3306,database=<span style="color: #800000">‘</span><span style="color: #800000">test</span><span style="color: #800000">‘</span>, user=<span style="color: #800000">‘</span><span style="color: #800000">root</span><span style="color: #800000">‘</span>,password=<span style="color: #800000">‘</span><span style="color: #800000">1234</span><span style="color: #800000">‘</span>,charset=<span style="color: #800000">‘</span><span style="color: #800000">utf8</span><span style="color: #800000">‘</span><span style="color: #000000">)
</span><span style="color: #008080"> 7</span> 
<span style="color: #008080"> 8</span> curor=<span style="color: #000000">con.cursor()
</span><span style="color: #008080"> 9</span> 
<span style="color: #008080">10</span> returns=curor.execute(<span style="color: #800000">‘</span><span style="color: #800000">select * from userinfo </span><span style="color: #800000">‘</span><span style="color: #000000">)
</span><span style="color: #008080">11</span> <span style="color: #000000">con.commit()
</span><span style="color: #008080">12</span> <span style="color: #008000">#</span><span style="color: #008000">如果是select，这里就要使用curor的fetchall，fetchone,fetchmany进行打查询;其他的增加，删除，修改都一样，只是select 比较</span>
<span style="color: #008080">13</span> <span style="color: #008000">#</span><span style="color: #008000">特殊</span>
<span style="color: #008080">14</span> <span style="color: #000000">curor.close()
</span><span style="color: #008080">15</span> <span style="color: #000000">con.close()
</span><span style="color: #008080">16</span> <span style="color: #0000ff">print</span><span style="color: #000000">(curor.fetchone())
</span><span style="color: #008080">17</span> <span style="color: #0000ff">print</span>(curor.fetchmany(3<span style="color: #000000">))
</span><span style="color: #008080">18</span> <span style="color: #0000ff">print</span>(curor.fetchall())

View Code

mysql的复杂查询，连接数据库

标签：本地 ted ble == ret 安装 .exe creat open

mysql的复杂查询，连接数据库

人气教程排行