一、安装MySQL-python
# -y MySQL-python
conn = MySQLdb.connect(user=<span style="color: #800000;">'<span style="color: #800000;">root<span style="color: #800000;">',passwd=<span style="color: #800000;">'<span style="color: #800000;">admin<span style="color: #800000;">',host=<span style="color: #800000;">'<span style="color: #800000;">127.0.0.1<span style="color: #800000;">'<span style="color: #000000;">)
conn.select_db(<span style="color: #800000;">'<span style="color: #800000;">test<span style="color: #800000;">'<span style="color: #000000;">)
cur = conn.cursor()
<div class="cnblogs_code">
= = sql % (,
<span style="color: #0000ff;">def <span style="color: #000000;"> selectdb():
sql = <span style="color: #800000;">'<span style="color: #800000;">select name from test where sort = "%s"<span style="color: #800000;">'<span style="color: #000000;">
exsql = sql % (<span style="color: #800000;">'<span style="color: #800000;">python<span style="color: #800000;">'<span style="color: #000000;">)
count =<span style="color: #000000;"> cur.execute(exsql)
<span style="color: #0000ff;">for row <span style="color: #0000ff;">in<span style="color: #000000;"> cur:
<span style="color: #0000ff;">print<span style="color: #000000;"> row
</span><span style="color: #0000ff;">print</span> <span style="color: #800000;">'</span><span style="color: #800000;">cursor move to top:</span><span style="color: #800000;">'</span><span style="color: #000000;">
cur.scroll(0,</span><span style="color: #800000;">'</span><span style="color: #800000;">absolute</span><span style="color: #800000;">'</span><span style="color: #000000;">)
row </span>=<span style="color: #000000;"> cur.fetchone()
</span><span style="color: #0000ff;">while</span> row <span style="color: #0000ff;">is</span> <span style="color: #0000ff;">not</span><span style="color: #000000;"> None:
</span><span style="color: #0000ff;">print</span><span style="color: #000000;"> row
row </span>=<span style="color: #000000;"> cur.fetchone()
</span><span style="color: #0000ff;">print</span> <span style="color: #800000;">'</span><span style="color: #800000;">cursor move to top:</span><span style="color: #800000;">'</span><span style="color: #000000;">
cur.scroll(0,</span><span style="color: #800000;">'</span><span style="color: #800000;">absolute</span><span style="color: #800000;">'</span><span style="color: #000000;">)
many </span>=<span style="color: #000000;"> cur.fetchmany(count)
</span><span style="color: #0000ff;">print</span><span style="color: #000000;"> many
<span style="color: #0000ff;">def<span style="color: #000000;"> deletedb():
sql = <span style="color: #800000;">'<span style="color: #800000;">delete from test where sort = "%s"<span style="color: #800000;">'<span style="color: #000000;">
exsql = sql % (<span style="color: #800000;">'<span style="color: #800000;">python<span style="color: #800000;">'<span style="color: #000000;">)
cur.execute(exsql)
conn.commit()
<span style="color: #0000ff;">return <span style="color: #800000;">'<span style="color: #800000;">delete success<span style="color: #800000;">'
<span style="color: #0000ff;">print<span style="color: #000000;"> insertdb()
<span style="color: #0000ff;">print<span style="color: #000000;"> insertdb()
selectdb()
<span style="color: #0000ff;">print deletedb()
注意顺序。 (编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|