On Friday, March 26, 2010 09:39 AM, Ray Van Dolson wrote:
On Fri, Mar 26, 2010 at 09:32:35AM +0800, Christopher Chan wrote:
Where'd you get your MySQLdb module from?
yum install MySQL-python
Well, don't know what to tell you:
$ rpm -qi MySQL-python Name : MySQL-python Relocations: (not relocatable) Version : 1.2.1 Vendor: CentOS Release : 1 Build Date: Fri 05 Jan 2007 08:40:16 PM PST Install Date: Thu 25 Mar 2010 06:35:52 PM PDT Build Host: builder1.centos.org Group : Development/Libraries Source RPM: MySQL-python-1.2.1-1.src.rpm Size : 283388 License: GPL Signature : DSA/SHA1, Tue 03 Apr 2007 05:25:09 PM PDT, Key ID a8a447dce8562897
Hmm, some slight differences...
Name : MySQL-python Relocations: (not relocatable) Version : 1.2.1 Vendor: CentOS Release : 1 Build Date: Sat 06 Jan 2007 12:38:14 PM HKT Install Date: Tue 16 Mar 2010 12:24:16 PM HKT Build Host: builder3.centos.org Group : Development/Libraries Source RPM: MySQL-python-1.2.1-1.src.rpm Size : 294516 License: GPL Signature : DSA/SHA1, Wed 04 Apr 2007 08:25:45 AM HKT, Key ID a8a447dce8562897
URL : http://sourceforge.net/projects/mysql-python/ Summary : An interface to MySQL Description : Python interface to MySQL
MySQLdb is an interface to the popular MySQL database server for Python. The design goals are:
Compliance with Python database API version 2.0Thread-safetyThread-friendliness (threads will not block each other)Compatibility with MySQL 3.23 and up$ python Python 2.4.3 (#1, Sep 3 2009, 15:37:12) [GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] on linux2 Type "help", "copyright", "credits" or "license" for more information.
import MySQLdb conn = MySQLdb.connect(user='rayvd', passwd='XXXXXX', db='bludgeon') cursor=conn.cursor() cursor.execute("SELECT * FROM quotes LIMIT 1")
1L
results = cursor.fetchone()
Oh brother, it looks like initialize() don't exist too...
con=MySQLdb.connection(passwd="XXXXXXXX",user="esf",db="maze_bs") curs=con.cursor()
Traceback (most recent call last): File "<stdin>", line 1, in ? AttributeError: cursor
curs=con.initialize()
Traceback (most recent call last): File "<stdin>", line 1, in ? AttributeError: initialize