The right way to ORDER BY a MySQL Question in Python

First, you have to the mysql.connector. In case you are not sure of find out how to get this setup, seek advice from The right way to Set up MySQL Driver in Python.

The right way to Type 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)

The right way 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",
  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)