Python MySQL Kada

Gida Tukewa

Za a iya amfani da kalaman "LIMIT" domin kwarewa yadda za a iya karewa daga siffar da a kai amfani da shi:

Mafi

Tukewa "customers" tabarfa gida 5:

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

Sake Mafi

Daga wuri na baya

Idan kwarin da a bace daga wuri 3 ya zo, sake gida 5, za a iya amfani da kalaman "OFFSET":

Mafi

Daga wuri 3 ya zo, sake gida 5:

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

Sake Mafi