数据库insert操作时,某个字段是自增序列如ID,但是想获取这个ID的值是多少,后者把这ID的值作为后续其他sql的参数,那要怎么做呢,其实很简单,可用last_insert_id
要获取MySQL自增ID序列,可用通过last_insert_id
当执行insert的时候,先不要commit,通过SELECT LAST_INSERT_ID();获取到自增序列后,再commit,否则获取到的是0
# -*- coding: utf-8 -*-
import xlrd
db_info = {'host':'', 'port':8899, 'user':'ducc', 'passwd':'', 'db':'', 'charset':'utf8'}#连接数据库
import pymysql
import sys
import traceback
# 插入dcf_services
inser_dcf_services = "INSERT INTO `dcf_services` ( `PARENT_SERVICES_ID`, `SERVICES_NAME`, `SERVICES_CODE`, `SERVICES_TYPE`, `CONCURRENT_NUM`, `PACKAGE_ID`, `START_PARAM`, `PROGRAM_NAME`, `SERVICES_TYPE_ID`, `BUS_CLUSTER_ID`,