Find out how to ORDER BY a MySQL Question in Python

First, you have to the mysql.connector. In case you are uncertain of get this setup, discuss with Find out how to Set up MySQL Driver in Python.

Find out how to Type the Results of a MySQL Question in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "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)

Find out how to 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 exchange the ASC with DESC as follows:

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "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)