Python： 将TXT文件写入MySQL

nidr

　　当前环境：

• 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即可。