import MySQLdb

import _mysql

ImportError DLL load failed: %1 不是有效的 Win32 应用程序

提示“Python 2.7 is required, which was not found in the registry”

#

# 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()

-- ----------------------------

-- Table structure for `t_user`

-- ----------------------------

USE pydb;

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) NOT NULL,

  `age` int(11) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of t_user

-- ----------------------------

import MySQLdb

conn = MySQLdb.Connect(

                       host="127.0.0.1",

                       port = 3306,

                       user = "user",

                       passwd="123456",

                       db="pydb",

                       charset='utf8')

print conn

cursor = conn.cursor()

print cursor

try:

    sql = "insert into t_user(name,age) values('wyf001', 28)"

    cursor.execute(sql)

    conn.commit()

except Exception as e:

    conn.rollback()

try:

    sql = "update t_user set age=29 where name = 'wyf001'"

    cursor.execute(sql)

    conn.commit()

except Exception as e:

    conn.rollback()

sql = "select id,name,age from t_user"

cursor.execute(sql)

rows = cursor.fetchall()

for row in rows:

    print row

try:

    sql = "delete from t_user where name = 'wyf001'"

    cursor.execute(sql)

    conn.commit()

except Exception as e:

    conn.rollback()