Saturday , September 18 2021
Home / Python / Python MySQL Order By

Python MySQL Order By

7 Python MySQL Order By

Python MySQL Order By

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 MySQL Order by Ascending

In [17]:
import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="",
  database="itronix"
)

mycursor = mydb.cursor()
sql = "SELECT * FROM customers ORDER BY name"

mycursor.execute(sql)
myresult = mycursor.fetchall()

for x in myresult:
    print(x)
(6, 'Atharv', 'Goa')
(1, 'Karan', 'Ludhiana')
(3, 'Keisha', 'Otawa 4')
(2, 'Kevin', 'Dublin 4')
(5, 'Priya', 'Delhi')
(7, 'Sia', 'Dubai')
(4, 'Varun', 'Ontario')

Python MySQL Order by Descending

In [18]:
import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="",
  database="itronix"
)

mycursor = mydb.cursor()
sql = "SELECT * FROM customers ORDER BY name DESC"

mycursor.execute(sql)
myresult = mycursor.fetchall()

for x in myresult:
    print(x)
(4, 'Varun', 'Ontario')
(7, 'Sia', 'Dubai')
(5, 'Priya', 'Delhi')
(2, 'Kevin', 'Dublin 4')
(3, 'Keisha', 'Otawa 4')
(1, 'Karan', 'Ludhiana')
(6, 'Atharv', 'Goa')

About Machine Learning

Check Also

Python MySQL Insert Into Table

4 Python MySQL Insert Into Table Python MySQL Insert Into Table¶To fill a table in …

Leave a Reply

Your email address will not be published. Required fields are marked *