Restrict a MySQL Question in Python

First, you will have the mysql.connector. In case you are not sure of easy methods to get this setup, discuss with Set up MySQL Driver in Python.

Restrict the Outcome Returned from MySQL in Python#

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  person = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM prospects LIMIT 10")
myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Begin From One other Place in MySQL from Python#

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  person = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM prospects LIMIT 10 OFFSET 5")
myresult = mycursor.fetchall()

for x in myresult:
  print(x)