Python： 将TXT文件写入MySQ

发布时间：2019-09-11 07:42:16编辑：auto阅读（1823）

    当前环境：

    • Windwos 10
    • Python 2.7
    • MySQL 5.5
    • PyCharm

    遇到的问题

    1. ImportError: No module named MySQLdb
      安装MySQLdb, 注意是windows命令符下，不是python环境下 
      pip install MySQLdb
    2. 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位的，否则报错

    1. 安装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即可。

关键字：

上一篇： Python监控服务器利器--psuti

下一篇： python爬取网站美女图片