Django使用mysql 语句

https://docs.djangoproject.com/en/dev/topics/db/sql/

 

from django.db import connection, transaction

 

 

def my_custom_sql():
    from django.db import connection, transaction
    cursor = connection.cursor()

    # Data modifying operation - commit required
    cursor.execute("UPDATE bar SET foo = 1 WHERE baz = %s", [self.baz])
    transaction.commit_unless_managed()

    # Data retrieval operation - no commit required
    cursor.execute("SELECT foo FROM bar WHERE baz = %s", [self.baz])
    row = cursor.fetchone()

    return row

connection.cursor() 得到数据库游标对象

transaction.commit_unless_managed() 提交所作的修改