Python MySQL – Limit number of rows selected from table
To select limited number of rows from a MySQL table in Python program,
- Create a connection to the MySQL database with user credentials and database name, using connect() function.
- Get cursor object to the database using cursor() function.
- Call execute() function on the cursor object, and pass the SELECT FROM table query with LIMIT clause.
- Call fetchall() function on the cursor object. The function returns an iterator to the records in the table. Each record is a tuple.
Consider that there is a schema named mydatabase in MySQL. The credentials to access this database are, user: root and password: admin1234, and there is a table named fruits in mydatabase.
In the following program, we select the rows from fruits table, but limit the number of records to two.
import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", password="admin1234", database="mydatabase" ) mycursor = mydb.cursor() mycursor.execute("SELECT * FROM fruits LIMIT 2") myresult = mycursor.fetchall() for row in myresult: print(row)
('Apple', 25, 'Canada') ('Avocado', 37, 'Mexico')
In this tutorial of Python Examples, we learned how to limit the number of records in the selection from a table in MySQL database, from a Python program.