Loading lesson path
Use the ORDER BY statement to sort the result in ascending or descending order. The ORDER BY keyword sorts the result ascending by default. To sort the result in descending order, use the DESC keyword.
Sort the result alphabetically by name: result:
Formula
import mysql.connector mydb = mysql.connector.connect(host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" ) mycursor = mydb.cursor()
sql = "SELECT * FROM customers ORDER BY name"
mycursor.execute(sql)Formula
myresult = mycursor.fetchall()
for x in myresult:print(x)Use the DESC keyword to sort the result in a descending order.
Sort the result reverse alphabetically by name:
Formula
import mysql.connector mydb = mysql.connector.connect(host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" )
Formula
mycursor = mydb.cursor()sql = "SELECT * FROM customers ORDER BY
name DESC"
mycursor.execute(sql)Formula
myresult = mycursor.fetchall()
for x in myresult:print(x)