利用python向mysql数据库插入timestamp

利用python向mysql数据库插入timestamp

• def insert_install_service_info(serviceName,nodeID,nodeIP='9.42.83.54'):

•    conn = MySQLdb.connect(host='172.17.46.15',user='root',passwd='huxin2010')

•    curs = conn.cursor()

•    serviceNode = {}

•    try:

•        conn.select_db('nodeInfo')

•    except Exception:

•        logger.error("the database you find does not exist!")

•    try:

•        sql = "insert into service3 values('NULL',%s,%s,%s,%s)"

•        now = datetime.datetime.now()

•        now = now.strftime("%Y-%m-%d %H:%M:%S")

•        values = [serviceName,nodeID,nodeIP,now]

•        curs.execute(sql,values)

•    except Exception:

•        logger.error("error: insert data fail")

•    conn.commit()

•    curs.close()

•    conn.close()