t.py

python_MySQL之间的几个小例子。对于python连接的数据库

import MySQLdb
import sys
try:
        conn = MySQLdb.connect(host = "localhost", user = "root", passwd = "myDBpass", db = "abc")  
except MySQLdb.Error, e:
        print "error %d: %s" % (e.args[0], e.args[1])
        sys.exit(1)
try:
    reload(sys)
    sys.setdefaultencoding('gb2312')

    cursor = conn.cursor()
    
    cursor.execute("drop table t")
    cursor.execute("create table t (id int(2),name varchar(20))")
    
    #conn.begin()
    cursor.execute('START TRANSACTION')
    
    cursor.execute('insert into t (id,name) values (34,%s)',('测试1'))
    cursor.execute('insert into t (id,name) values (33,%s)',('测试2'))
    
    cursor.execute('commit')
    
    
    cursor.execute("select id,name from t")
    data = cursor.fetchall() 
    for i  in  data:
        id,name = i
        name = name.decode('utf-8')
    
        print data
        print id,name
     
except MySQLdb.Error, e:
         print "error %d: %s" % (e.args[0], e.args[1])
    
cursor.close()    
conn.close()