Kifaa cha Python MySQL Limit

Uadilifu wa Matokeo

Unaweza kutumia herufi "LIMIT" kuikataza uadilifu wa rekodi kutoka kwenye uharibifu:

Mfano

Chaguo "customers" kwa rekodi mbili na nne:

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()
kwa x katika myresult:
  print(x)

Kuagiza mifano

Kuanza kutoka eneo nyingine

Ikiwa ni lazima kuharibika hadi rekodi ya tatu na kurekoda 5 rekodi, unaweza kutumia herufi "OFFSET":

Mfano

Kisha kuharibika kutoka kiwango 3 hadi 5 rekodi:

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()
kwa x katika myresult:
  print(x)

Kuagiza mifano