Choose From MySQL in Python

First, you will have the mysql.connector. In case you are not sure of how one can get this setup, check with Set up MySQL Driver in Python.

Choose From a MySQL Desk 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")
myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Choose Columns From a MySQL Desk in Python

import mysql.connector

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

mycursor = mydb.cursor()
mycursor.execute("SELECT title, tackle FROM prospects")
myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Fetch Solely a Single Row 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")
myresult = mycursor.fetchone()

print(myresult)