#encoding=utf-8 # __author__ = 'Jason Han' import MySQLdb try: conn = MySQLdb.connect(host = 'localhost',user = 'root', passwd = '', port = 3306) cur = conn.cursor() cur.execute('select * from test.test1') rows = cur.fetchall(); print rows cur.close() conn.close() except MySQLdb.Error,e: print"Mysql Error %d: %s" %(e.args[0],e.args[1])
具体连接到某个数据库的某个表用 select * from test.test1.