Learn how to Choose From MySQL in Python

First, you will want the mysql.connector. In case you are uncertain of methods to get this setup, seek advice from Learn how to Set up MySQL Driver in Python.

Learn how to 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)

Learn how to 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 identify, handle FROM prospects")
myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Learn how to 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)