Calculating average of a column using python flask from MySQL Database : NameError: name 'rate' is not defined
you can calculate avg for column as like below
c.execute("""SELECT AVG(rate) AS avg_rate FROM jacket """)avg = c.fetchone()
Firstly you can connect to db as first line.Then you should create a cursor for write queries.You can create a query as a string.If you give your query as a parameter to execute function and fetch your result you can handle it.
conn = mysql.connect()cursor =conn.cursor()query = "SELECT AVG(rate) from User"cursor.execute(query)result = cursor.fetchall() # or fetchone()