mysql自增字符串变量

import mysql.connector

def get_next_id(cursor, table_name):
    cursor.execute(f"SELECT MAX(my_id) FROM {table_name}")
    max_id = cursor.fetchone()[0]
    if max_id is None:
        next_id = 'ID00001'
    else:
        next_id = 'ID' + str(int(max_id[2:]) + 1).zfill(5)
    return next_id

# 连接数据库
db = mysql.connector.connect(host="localhost", user="user", password="password", database="mydatabase")
cursor = db.cursor()

# 获取下一个ID
next_id = get_next_id(cursor, 'mytable')

# 插入数据
cursor.execute(f"INSERT INTO mytable (my_id, name) VALUES ('{next_id}', 'John Doe')")
db.commit()

cursor.close()
db.close()