ORDER BY a MySQL Question in Python

First, you have to the mysql.connector. In case you are not sure of how one can get this setup, seek advice from 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 identify"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Change Route of MySQL Order in Python

You may change the order of the type by merely setting the order course.

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 change 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 identify DESC"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)