Python 版本:2.6
下载地址:http://www.python.org/download/releases/2.6.1/
下载msi文件并安装
MySQLdb版本: MySQL-python-1.2.2.win32-py2.6.exe
下载地址:http://home.netimperia.com/files/misc/MySQL-python-1.2.2.win32-py2.6.exe
参见:http://sourceforge.net/forum/forum.php?thread_id=2316047&forum_id=70460
常见问题:
1.ImportError: DLL load failed: 找不到指定的模块。
—————————————————————————————————-
D:\Program Files\Python2.6>python
Python 2.6.1 (r261:67517, Dec 4 2008, 16:51:00) [MSC v.1500 32 bit (Intel)] on win32
Type “help”, “copyright”, “credits” or “license” for more information.
>>> import MySQLdb
Traceback (most recent call last):
File “<stdin>”, line 1, in <module>
File “D:\Program Files\Python2.6\Lib\site-packages\MySQLdb\__init__.py”, line 19, in <module>
>>> import _mysql
ImportError: DLL load failed: 找不到指定的模块。
—————————————————————————————————-
解决方法:下载libmmd.dll(附件)和libguide40.dll(附件)两个dll文件并复制到python安装目录的Lib\site-packages下。
参见:http://sourceforge.net/forum/message.php?msg_id=5613887
2.ImportError: DLL load failed: 找不到指定的模块。
—————————————————————————————————-
D:\Program Files\Python2.6>python
Python 2.6 (r26:66721, Oct 2 2008, 11:35:03) [MSC v.1500 32 bit (Intel)] on win32
Type “help”, “copyright”, “credits” or “license” for more information.
>>> import MySQLdb
D:\Program Files\Python2.6\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet
—————————————————————————————————-
解决方法:
1、
找到python2.6安装目录\Lib\site-packages\MySQLdb
把__init__.py
from sets import ImmutableSet
class DBAPISet(ImmutableSet):
替换成
class DBAPISet(frozenset):
2、找到python2.6安装目录\Lib\site-packages\MySQLdb
把converters.py
from sets import BaseSet, Set
这行删除
3、依然这个converters.py文件
把48行和128行的 Set 修改成小写的 set
修改后如下:
line 48: return set([ i for i in s.split(',') if i ])
line 128: set: Set2Str,
TEST:
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='root', passwd='root', db='test')
cursor = conn.cursor()
count = cursor.execute('select * from stu')
print 'total %s' % count
分享到:
相关推荐
详细介绍了第一次使用eclipse时,在Eclipse中配置python的IDE教程,图文并茂
Have you ever tried to install macOS Mojave on your laptop Windows 10? but, before visiting begin our topic concerning install macOS Mojave Final. Let Pine Tree State introduce or provide info to you ...
How To Install nginx on CentOS 6 with yum
How to install mysql on ubuntu
How to install OMNET++ on Ubuntu 12.10
### how to study python ###### ANSWER Python is a great language for beginners as well as experienced programmers. There are various ways to learn Python, and some of the best sources are listed ...
How to install the latest Python 3 interpreter and using shell and the editor to create Python programs How to format and print information to the screen using Python commands How to define ...
The purpose of this book is to show you how to write Python programs in good idiomatic Python 3 style, and to be a useful reference for the Python 3 language after the initial reading. Although Python...
How to install VNC server on Centos 7
i write a document for how to config the Python 3.0 environment. it can help the Python newer
The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database. This book takes you ...
NULL 博文链接:https://netli.iteye.com/blog/671654
Learn how to use Python and its structures, how to install Python, and which tools are best suited for data analyst work. This book provides you with a handy reference and tutorial on topics ranging ...
How to install NiftyReg - Linux and MacOs
Python How to Program
No matter what level of experience and skill you have with computers, you can rest assured that this course will suit your needs from the first step: walking you through how to install Python 3 and ...
长截图;如何在Windows系统上安装node.js和NPM;环境配置参考。
在Ubuntu18.04中安装NFS服务器以及配置NFS 客户端,详细安装步骤过程,简单实用,一学就会
Chapter 1 explains how to install Python and makes sure all readers have the closest,standardized environment. I almost removed this chapter since the book is not intended for beginners. But it was ...
How To Install Custom Themes