最简单易懂的python操作mysql示例

最简单易懂的python操作mysql示例：

#!/usr/bin/env python
# -*- coding : UTF-8 -*-
# Author : wanghaoyu -
# QQ : 42030925
# Last modified:2010-06-11 17:17
# Filename:mysql_test.py
# Description:

import MySQLdb;
import sys,os,re

db_host = "localhost"
db_name = "test1"
db_user = "root"
db_user_passwd = "111111"

conn = MySQLdb.connect(db_host,db_user,db_user_passwd,db_name)
cursor = conn.cursor()
desc = "select * from emp;"
#desc = "show create table emp;"
cursor.execute(desc)
resualts = cursor.fetchall()
for resualt in resualts:
  print resualt;

cursor.close()
conn.commit()
conn.close()

运行结果：

 

('zzx1', datetime.date(2000, 1, 1), Decimal('2000.00'), 1L)
('lisa', datetime.date(2003, 2, 1), Decimal('4000.00'), 2L)
('dony', None, Decimal('1000.00'), None)

郁闷 为什么我的插入代码功能不能用呢？ 我插入代码 点击确定就没反应了。。。