Learn how to Choose From MySQL in Python

First, you’ll need the mysql.connector. In case you are not sure of the right way to get this setup, discuss with 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 clients")
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, tackle FROM clients")
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 clients")
myresult = mycursor.fetchone()

print(myresult)