利用sql语句进行增删改查

时间:2023-03-08 18:18:07

1.查询
  函数:raw(sql语句)
  语法:Entry.objects.raw(sql)
  返回:QuerySet
2.增删改
  from django.db import connection

  def doSQL(request):
    with connection.curso() as cursor:
    sql = "update user set age=age+10"
    cursor.execute(sql)
    return ''