Django中使用views.py自动递增

Question

if request.method == 'POST':
    m = sql.connect(host="localhost",user="root",password="admin@123", database= "ticketsys")
    cursor = m.cursor()

    ticketid = request.POST['ticketid']
    email = request.POST['email']
    username = request.POST.get('username')
    checkbox = request.POST['checkbox']
    adult = request.POST['adult']
    fromstation = request.POST['fromstation']
    tostation = request.POST['tostation']
    rate = request.POST["rate"]
    date = request.POST.get('date')
    usermessage = request.POST['usermessage']


    c = "insert into ticketsys.ticketgen values('{}','{}','{}','{}','{}','{}','{}','{}','{}','{}')".format(ticketid,email,username,checkbox,adult,fromstation,tostation,rate ,date, usermessage)
    cursor.execute(c)
    m.commit()

    return render(request, 'account/ticketconf.html')


else:
    return render(request, 'account/ticket.html')

在这里，票证 ID 是自动递增的，但它显示错误。

1366 (HY000): Incorrect integer value: '' for column 'ticketid' at row 1

解决这个问题的最好方法是什么。这样，无需创建模型，我就可以将数据发布到 mysql 中。

SQL-图像