Python： 將TXT文件寫(xiě)入MySQL

當(dāng)前環(huán)境：

• Windwos 10
• Python 2.7
• MySQL 5.5
• PyCharm

遇到的問(wèn)題

1. ImportError: No module named MySQLdb
   安裝MySQLdb, 注意是windows命令符下，不是python環(huán)境下

   pip install MySQLdb

2. error: Microsoft Visual C++ 9.0 is required. Get it from http://aka.ms/vcpython27

安裝MySQLdb時(shí)，報(bào)錯(cuò)缺少Visual C++ 9.0。解決方法：下載并安裝MySQL-python 1.2.5 . https://pypi.python.org/pypi/MySQL-python/1.2.5

注意: 64位系統(tǒng)的，請(qǐng)安裝64位的，否則報(bào)錯(cuò)

3. 安裝MySQL-python時(shí)報(bào)錯(cuò)：Python version 2.7 required, which was not found in the registry
   原因： 這是在注冊(cè)表不能識(shí)別python2.7,原因windows是64位，安裝的python是32位
   解決方法：
   1.在任意盤(pán)符文件夾新建一個(gè)register.py文件， 將如下代碼拷貝進(jìn)去:

   
   #
   # 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.  定位到該文件所在目錄，運(yùn)行python register.py 。提示 Python 2.7 is now registered! 表示成功。 繼續(xù)執(zhí)行MySQL-python即可。