Can you run a raw MySQL query in Django without a model?

Question

I am still learning Django and I'm just now getting into connectors to MySQL. What I'm trying to figure out is how I would go about querying a db/table that I am not creating with a model in Django.

Do I have to recreate the table as a model in order to have it talk to Django? If so, would that basically mean just recreating my structure with a model then importing my data to the new table?

Sorry if this is a goofy question, I appreciate any help you can give!

Answer 1

Yes, you can query the database table without model by using connection cursor

from django.db import connection

def my_custom_sql(self):
    cursor = connection.cursor()
    cursor.execute("SELECT * FROM table_name where id=1")
    row = cursor.fetchall()
    return row