How to use stored procedure or function created in mysql in django?

Question

As I am learning django and MySql , I am creating a web page and want to use PlSql queries like triggers and procedure in my website using django. I have made connection of MySql and django. Can anyone help me how to proceed further. Thank you in advance!

Check out this [link](https://stackoverflow.com/q/805393/9456405) — Muhammed Sidan, Mar 31 '20 at 16:05

score 0 · Answer 1 · answered Mar 31 '20 at 16:27

0

You can run as SQL query like:

from django.db import connection

with connection.cursor() as cursor:
    cursor.execute("SELECT add(1,2);")
    resp= cursor.fetchall()

answered Mar 31 '20 at 16:27

DARK_C0D3R

2,075
16
21

2

Thank you so much! – Harsh760 Mar 31 '20 at 16:59

How to use stored procedure or function created in mysql in django?

1 Answers1