Python Tutorials · Python MySQL

MySQL Order By

Learn all about MySQL Order By in this comprehensive tutorial.

5 min read advanced

•Use the ORDER BY statement to sort the result in ascending or descending order.
•Use the DESC keyword to sort the result in a descending order.

Sort the Result

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.

python

import mysql.connectormydb = mysql.connector.connect(  host="localhost", 
  user="yourusername",  password="yourpassword",  database="mydatabase")mycursor = 
  mydb.cursor()sql = "SELECT * FROM customers ORDER BY name"mycursor.execute(sql)
  myresult = mycursor.fetchall()for val_1 in myresult:  print(val_1)

ORDER BY DESC

Use the DESC keyword to sort the result in a descending order.

python

import mysql.connectormydb = mysql.connector.connect(  host="localhost", 
  user="yourusername",  password="yourpassword",  database="mydatabase")
mycursor = mydb.cursor()sql = "SELECT * FROM customers ORDER BY 
  name DESC"mycursor.execute(sql)myresult = mycursor.fetchall()for val_1 in myresult:  
  print(val_1)

Module quiz

2 questions

Which of the following is true about MySQL Order By?

It is strictly typedIt is evaluated at runtimeIt requires explicit memory managementIt is deprecated

What is the most common pitfall when working with MySQL Order By?

SyntaxErrorIndentationErrorNameErrorTypeError

Answer all questions to submit.

MySQL Where

MySQL Delete

MySQL Order By

AI Summary

Sort the Result

ORDER BY DESC

Module quiz