The right way to ORDER BY a MySQL Question in Python

First, you will want the mysql.connector. If you’re uncertain of easy methods to get this setup, confer with The right way to Set up MySQL Driver in Python.

The right way to Kind 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 prospects ORDER BY identify"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

The right way to Change Path of MySQL Order in Python#

You’ll be able to 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 substitute 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 prospects ORDER BY identify DESC"
mycursor.execute(sql)

myresult = mycursor.fetchall()

for x in myresult:
  print(x)