How you can ORDER BY a MySQL Question in Python

First, you will want the mysql.connector. In case you are not sure of methods to get this setup, check with How you can Set up MySQL Driver in Python.

How you can Kind the Results of a MySQL Question in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  person = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
sql = "SELECT * FROM prospects ORDER BY identify"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

How you can Change Course of MySQL Order in Python

You’ll be able to change the order of the type by merely setting the order route.

By default, it’s set to ORDER BY <column_name> ASC, which units the response in ascending order.

If you wish to change it, you merely exchange the ASC with DESC as follows:

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  person = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
sql = "SELECT * FROM prospects ORDER BY identify DESC"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)