Question

How to run SQL query in MySQL database with ORDER BY statement to sort the result in Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
    
import mysql.connector
    
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
   
db_cursor = db.cursor()

sql = "SELECT * FROM workers ORDER BY first_name"

db_cursor.execute(sql)

result = db_cursor.fetchall()
 
for row in result:
    print(row)
 
db.close()

 
'''
run:
  
(3, 'Amy', 'Python Programmer')
(4, 'Arthur', 'Java Programmer')
(2, 'Aurora', 'C++ Programming')
(1, 'Fox', 'C Programmer')
(5, 'R2D2', 'Super Programmer')
 
'''

 

70+ SQL courses for beginners and professionals

Answer 2

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
    
import mysql.connector
    
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
   
db_cursor = db.cursor()

sql = "SELECT * FROM workers ORDER BY first_name DESC"

db_cursor.execute(sql)

result = db_cursor.fetchall()
 
for row in result:
    print(row)
 
db.close()

 
'''
run:
  
(5, 'R2D2', 'Super Programmer')
(1, 'Fox', 'C Programmer')
(2, 'Aurora', 'C++ Programming')
(4, 'Arthur', 'Java Programmer')
(3, 'Amy', 'Python Programmer')
 
'''

 

70+ SQL courses for beginners and professionals