Loading lesson path
You can limit the number of records returned from the query, by using the "LIMIT" statement:
Select the 5 first records in the "customers" table:
Formula
import mysql.connector mydb = mysql.connector.connect(host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" ) mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers LIMIT 5")Formula
myresult = mycursor.fetchall()
for x in myresult:print(x)If you want to return five records, starting from the third record, you can use the "OFFSET" keyword:
Start from position 3, and return 5 records:
Formula
import mysql.connector mydb = mysql.connector.connect(host="localhost", user=" yourusername ", password=" yourpassword ", database="mydatabase" ) mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM customers LIMIT 5
OFFSET 2")Formula
myresult = mycursor.fetchall()
for x in myresult:print(x)