Insert to mysql database through Rawsql

Question

I want to perform custome sql query on mysql database table to store the record .What is the way to perform insert query through rawsql.

I am using following model

class Student(models.Model):
    userid = models.CharField(db_column='UserId', primary_key=True, max_length=12)  # Field name made lowercase.
    firstname = models.CharField(db_column='FirstName', max_length=30)  # Field name made lowercase.
    middlename = models.CharField(db_column='MiddleName', max_length=30, blank=True, null=True)  # Field name made lowercase.
    lastname = models.CharField(db_column='LastName', max_length=30)  # Field name made lowercase.
    password = models.CharField(db_column='Password', max_length=50, blank=True, null=True)  # Field name made lowercase.

and trying to insert values through raw method because want to store passwoed through md5('') provided by mysql:

st = Student.object.raw("Insert into Student values(%s,%s,%s,%s,md5(%s))",['ST1','Fname','Mname','Lname','Pwd']);

but i am not getting how to execute this.Is there any way ?

Not sure if raw does INSERTs, but you should read more here - docs.djangoproject.com/en/1.10/topics/db/sql/… — shad0w_wa1k3r
– shad0w_wa1k3r, Commented Mar 8, 2017 at 7:48

Meska · Accepted Answer · 2017-03-08 07:51:46Z

4

Here a simple example:

from django.db import connections

cursor = connections['default'].cursor()
cursor.execute("INSERT INTO TABLE(field1,field2) VALUES( %s , %s )", [value1, value2])

answered Mar 8, 2017 at 7:51

Meska

1911 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert to mysql database through Rawsql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related