首页 > 数据库技术 > 详细

Instance Three: SELECT * FROM DATABASE

时间:2016-01-05 15:12:37      阅读:314      评论:0      收藏:0      [点我收藏+]
#!/usr/bin/env python
#--*-- coding:utf-8 --*--
__author__ = ‘Kevin‘

import MySQLdb as mdb
import sys

con = mdb.connect(‘localhost‘,‘root‘,‘redhat‘,‘test‘)

try:
    with con:
        cur = con.cursor()
        cur.execute("SELECT * FROM Writers")

        rows = cur.fetchall()

        for row in rows:
            print row
finally:
    con.close()

 Result:

(1L, ‘Jack London‘)
(2L, ‘Tik Tok‘)
(3L, ‘Harry Potter‘)

 

#!/usr/bin/env python
#--*-- coding:utf-8 --*--
__author__ = ‘Kevin‘

import MySQLdb as mdb
import sys

con = mdb.connect(‘localhost‘,‘root‘,‘redhat‘,‘test‘)

try:
    with con:
        cur = con.cursor()
        cur.execute("SELECT * FROM Writers")

        numrows = int(cur.rowcount)

        for i in range(numrows):
            row = cur.fetchone()
            print row[0],row[1]
finally:
    con.close()

 

Instance Three: SELECT * FROM DATABASE

原文:http://www.cnblogs.com/magicpower/p/5102309.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!