Methods to Choose From MySQL in Python

First, you have to the mysql.connector. In case you are not sure of tips on how to get this setup, seek advice from Methods to Set up MySQL Driver in Python.

Methods 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)

Methods 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 title, deal with FROM prospects")
myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Methods 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)