Choose From MySQL in Python

First, you will want the mysql.connector. If you’re uncertain of methods to 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",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM clients")
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",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
mycursor.execute("SELECT title, tackle FROM clients")
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",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM clients")
myresult = mycursor.fetchone()

print(myresult)