python 获取表当前最大id值

来源:互联网 发布:kerasys洗发水知乎 编辑:程序博客网 时间:2024/05/19 00:56
#!/usr/bin/python# -*- coding:utf-8 -*-#__author__='Kakarotto'import MySQLdbconn = MySQLdb.connect(        host='localhost',        port=3306,        user='root',        passwd='1qazxcde3@wsx',        db='phonedata',    )    cur = conn.cursor()    sqlii="select max(id) from phoneto"    cur.execute(sqlii)    conn.commit()    maxnumber=cur.fetchall()    for row in maxnumber:        countori=row[0]    count= countori+1 #get primarary key new value    print count
0 0
原创粉丝点击