Python操作Mysql数据库

#-*-coding:utf8-*-
__author__ = 'yangjing'
import MySQLdb

#查询。
def select(host="",user="root",password="",port=3306,db="",sql=""):
    connect = MySQLdb.connect(host=host,user=user,passwd=password,port=port,db=db,charset='utf8')
    cursor = connect.cursor()
    try:
        cursor.execute(sql)
        result = cursor.fetchall()
    except Exception as ex:
        print ex
    cursor.close()
    connect.close()
    return result

#插入。可插入多条记录，例value=(("abc"),("def"))；单条插入时，例value=(("abc"),)
def insert(host="",user="root",password="",port=