First, you will want the mysql.connector. In case you are uncertain of the way to get this setup, discuss with The best way to Set up MySQL Driver in Python.
The best way 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)
The best way 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)
The best way 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)
