无法从mysql表中删除数据，该表是使用Django从HTML中的表单中提取的

GRANT DELETE ON your_database.your_table TO 'your_user'@'localhost';

ALTER TABLE child_table DROP FOREIGN KEY fk_name;

# models.py
class YourModel(models.Model):
    # your fields here

# views.py
from django.shortcuts import get_object_or_404
from django.http import HttpResponse
from .models import YourModel

def delete_data(request, pk):
    data = get_object_or_404(YourModel, pk=pk)
    data.delete()
    return HttpResponse("Data deleted successfully")

from django.db import transaction

@transaction.atomic
def delete_data(request, pk):
    data = get_object_or_404(YourModel, pk=pk)
    data.delete()
    return HttpResponse("Data deleted successfully")

# views.py
from django.shortcuts import render, get_object_or_404, redirect
from .models import YourModel

def delete_view(request, pk):
    if request.method == 'POST':
        data = get_object_or_404(YourModel, pk=pk)
        data.delete()
        return redirect('success_url')  # 重定向到成功页面
    return render(request, 'delete_confirmation.html', {'data': data})