How you can Restrict a MySQL Question in Python

First, you’ll need the mysql.connector. If you’re uncertain of find out how to get this setup, discuss with How you can Set up MySQL Driver in Python.

How you can Restrict the Outcome Returned from MySQL in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "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)

How you can Begin From One other Place in MySQL from Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "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)