https://mediawiki.zeropage.org/index.php?action=history&feed=atom&title=Python%2FDataBase 2026-05-15T19:01:44Z Revision history for this page on the wiki MediaWiki 1.39.8 https://mediawiki.zeropage.org/index.php?title=Python/DataBase&diff=84859&oldid=prev 2026-03-27T00:29:07Z

<p>Repair batch-0003 pages from live compare</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 00:29, 27 March 2026</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l23">Line 23:</td> <td colspan="2" class="diff-lineno">Line 23:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  res = cur.fetchall()</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  res = cur.fetchall()</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  res = cur.fetchmany(10)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  res = cur.fetchmany(10)</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  print res<del style="font-weight: bold; text-decoration: none;">[</del>x<del style="font-weight: bold; text-decoration: none;">][</del>x<del style="font-weight: bold; text-decoration: none;">]</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  print res<ins style="font-weight: bold; text-decoration: none;">&amp;#91;</ins>x<ins style="font-weight: bold; text-decoration: none;">&amp;#93;&amp;#91;</ins>x<ins style="font-weight: bold; text-decoration: none;">&amp;#93;</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  cur.close()</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  cur.close()</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 참고 ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 참고 ==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [http://www.python.org/peps/pep-0249.html APISpec2.0설명서]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [http://www.python.org/peps/pep-0249.html APISpec2.0설명서]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>zeropage 에서 파이선 공부할 사람은 필요한 모듈있으면 게시판에 올리기 바람. - &amp;#91;eternalbleu&amp;#93;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>zeropage 에서 파이선 공부할 사람은 필요한 모듈있으면 게시판에 올리기 바람. - &amp;#91;eternalbleu&amp;#93;</div></td></tr> </table>

Maintenance script https://mediawiki.zeropage.org/index.php?title=Python/DataBase&diff=38052&oldid=prev 2021-02-07T05:24:09Z

<p></p> <p><b>New page</b></p><div>__TOC__<br /> = Mysql =<br /> * [http://sourceforge.net/projects/mysql-python Mysql모듈다운로드]<br /> ** [http://www.python.org/topics/database/modules.html 기타모듈다운로드]<br /> == 사용법 ==<br /> * 아래 소스는 파이썬 DB API Spec 2.0 에 있는 것들을 사용해서 작성함(즉 다른 모듈에서도 동일하게 사용가능)<br /> * connect 에<br /> host - hostname (NULL : default)<br /> user - username (NULL)<br /> passwd - password (no password)<br /> db - database name (NULL)<br /> port - integer, TCP/IP port<br /> unix_socket - TCP를 사용할 unix소켓의 위치<br /> client_flag - integer, 필요할 경우 사용하기 위한 flag (0)<br /> 을 인자로 넣을 수 있다.<br /> import MySQLdb<br /> con =MySQLdb.connect(user=&quot;name&quot;, passwd=&quot;password&quot;, db=&quot;databasename&quot;)<br /> cur = con.cursor()<br /> cur.execute(&quot;select * from owiki_page_name&quot;)<br /> print cur.description<br /> print cur.rowcount<br /> res = cur.fetchone()<br /> res = cur.fetchall()<br /> res = cur.fetchmany(10)<br /> print res[x][x]<br /> cur.close()<br /> == 참고 ==<br /> * [http://www.python.org/peps/pep-0249.html APISpec2.0설명서]<br /> zeropage 에서 파이선 공부할 사람은 필요한 모듈있으면 게시판에 올리기 바람. - &amp;#91;eternalbleu&amp;#93;</div>

imported>Unknown