Result Sort

We can sort the result by using order by statement in the program.

import mysql.connector

mycon= mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="1234",
  database="college"
)

mycur = mycon.cursor()

cmd = "SELECT * FROM students ORDER BY name"

mycur.execute(cmd)

result = mycur.fetchall()

for x in result:
  print(x)

Output

C:\Users\laptop>python demo.py
 ('Aditi', 'Lucknow', '564356', 6)
('Devansh', 'Kolkata', '345647', 10)
('Himanshu', 'Pune', '76556', 7)
('Rajat', 'Mumbai', '564464', 9)
('Reema', 'Jaipur', '65345', 11)
('Rohan ', 'New Delhi', '987654', 5)
('Vishal', 'Nainital', '765435', 8)
>>>

Reverse Sort

Desc order by used for shown data in decreasing order.

Program

import mysql.connector

mycon= mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="1234",
  database="college"
)

mycur = mycon.cursor()

cmd = "SELECT * FROM students ORDER BY name desc"

mycur.execute(cmd)

result = mycur.fetchall()

for x in result:
  print(x)

Output

C:\Users\laptop>python demo.py
  (4,'Vishal', 'Nainital',7654356445),
  (1,'Rohan ', 'New Delhi',9876543212),
  (7,'Reema', 'Jaipur',653453455),
  (5,'Rajat', 'Mumbai',5644644456),
  (3,'Himanshu', 'Pune',7655656564),
  (6,'Devansh', 'Kolkata',3456476545),
  (2,'Aditi', 'Lucknow',5643564444),
Subscribe Now