Python MySQL Kama ga Ayyan

Ayyan Kudu na ayyan a tsara

Yantara ORDER BY ka ayyan a tsara a tsari kudu ko a tsari kudu.

Kama ga ORDER BY ayyan a tsara a tsari kudu, yantara DESC ka ayyan a tsara a tsari kudu.

Dikkita

Ayyan Kudu ga ayyan name na a tsara, nuna:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers" ORDER BY name"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
  print(x)

Harci Dikkita

Ayyan Kudu

Yantara DESC ka ayyan a tsara a tsari kudu.

Dikkita

Ayyan Kudu ga ayyan name na ayyan a tsara:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers ORDER BY name" DESC"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
  print(x)

Harci Dikkita