Python mysql插入数据

操作mysql和其他的方式例如javaweb 都是一样的   

需要首先安装 MySQLdb模块

#-*- coding:UTF-8-*-'''Created on 2015-1-25@author: huangpeng03'''import sysimport MySQLdb import syshost = 'localhost'user = 'root'passwd = 'peng@2014'db = 'rominfo'if __name__ == '__main__':    try:        conn = MySQLdb.connect(host,user,passwd,db)     except Exception,e:        print e        sys.exit()    cursor = conn.cursor()    sql = 'insert into apkinfo  values (%s,%s,%s)'    values = ('apkmd51','rommd51','2015-01-25')    try:        print cursor.execute(sql,values)        cursor.close()        conn.commit()        conn.close()    except Exception,e:        print e    

记得 conn需要commit一把 以及close