Python MySQL Order By

Python MySQL Order By Example

# import connector class from mysql module.
import mysql.connector as myconn
mydb = myconn.connect(
  host = 'localhost',
  user = 'root',
  password = '',
  database = 'python_db'
)
db_cursor = mydb.cursor()

# sort records in descending order.
query = "SELECT * FROM users ORDER BY id DESC"
db_cursor.execute(query)
rows = db_cursor.fetchall()
for row in rows : print(row)

Output

C:\Users\Rahulkumar\Desktop\python>python mysql_sort.py
(8, 'Raju', 'verma', None)
(5, 'Gyan Singh', 'Yadav', 'gyanxyz@email.com')
(4, 'Girish', 'Kumar', None)
(2, 'Mohit', 'Kumar', 'xyz@gmail.com')
(1, 'Rahul', 'Kumar', 'changedEmail@gmail.com')

import mysql.connector as myconn
mydb = myconn.connect(
  host = 'localhost',
  user = 'root',
  password = '',
  database = 'python_db'
)
db_cursor = mydb.cursor()

# get last 3 records.
query = "SELECT * FROM users ORDER BY id DESC LIMIT 3"
db_cursor.execute(query)
rows = db_cursor.fetchall()
for row in rows : print(row)

Output

C:\Users\Rahulkumar\Desktop\python>python mysql_sort.py
(8, 'Raju', 'verma', None)
(5, 'Gyan Singh', 'Yadav', 'gyanxyz@email.com')
(4, 'Girish', 'Kumar', None)