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),