Python： 将TXT文件写入MySQ
当前环境：
- Windwos 10
- Python 2.7
- MySQL 5.5
- PyCharm
遇到的问题
- ImportError: No module named MySQLdb 安装MySQLdb, 注意是windows命令符下，不是python环境下 pip install MySQLdb
- error: Microsoft Visual C++ 9.0 is required. Get it from http://aka.ms/vcpython27
安装MySQLdb时，报错缺少Visual C++ 9.0。解决方法：下载并安装MySQL-python 1.2.5 . https://pypi.python.org/pypi/MySQL-python/1.2.5
注意: 64位系统的，请安装64位的，否则报错
- 安装MySQL-python时报错：Python version 2.7 required, which was not found in the registry 原因： 这是在注册表不能识别python2.7,原因windows是64位，安装的python是32位 解决方法： 1.在任意盘符文件夹新建一个register.py文件， 将如下代码拷贝进去: # # script to register Python 2.0 or later for use with win32all # and other extensions that require Python registry settings # # written by Joakim Loew for Secret Labs AB / PythonWare # # source: # http://www.pythonware.com/products/works/articles/regpy20.htm # # modified by Valentine Gogichashvili as described in http://www.mail-archive.com/distutils-sig@python.org/msg10512.html
import sys
from _winreg import *
tweak as necessary
version = sys.version[:3] installpath = sys.prefix
regpath = "SOFTWARE\Python\Pythoncore\%s\" % (version) installkey = "InstallPath" pythonkey = "PythonPath" pythonpath = "%s;%s\Lib\;%s\DLLs\" % ( installpath, installpath, installpath )
def RegisterPy(): try: reg = OpenKey(HKEY_CURRENT_USER, regpath) except EnvironmentError as e: try: reg = CreateKey(HKEY_CURRENT_USER, regpath) SetValue(reg, installkey, REG_SZ, installpath) SetValue(reg, pythonkey, REG_SZ, pythonpath) CloseKey(reg) except: print " Unable to register!" return print "--- Python", version, "is now registered!" return if (QueryValue(reg, installkey) == installpath and QueryValue(reg, pythonkey) == pythonpath): CloseKey(reg) print "=== Python", version, "is already registered!" return CloseKey(reg) print " Unable to register!" print "*** You probably have another Python installation!"
if name == "main": RegisterPy()
2. 定位到该文件所在目录，运行python register.py 。提示 Python 2.7 is now registered! 表示成功。 继续执行MySQL-python即可。