ORDER BY a MySQL Question in Python

First, you’ll need the mysql.connector. If you’re not sure of easy methods to get this setup, discuss with Set up MySQL Driver in Python.

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 clients ORDER BY title"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Change Course of MySQL Order in Python

You’ll be able to change the order of the kind by merely setting the order path.

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 substitute 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 clients ORDER BY title DESC"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)