Python Tutorials · Python MySQL

MySQL Select

Learn all about MySQL Select in this comprehensive tutorial.

5 min read advanced

MySQL Insert

MySQL Where

•To select from a table in MySQL, use the "SELECT" statement:
•To select only some of the columns in a table, use the "SELECT" statement followed by the column name(s):
•If you are only interested in one row, you can use the fetchone() method.

Select From a Table

To select from a table in MySQL, use the "SELECT" statement:

python

import mysql.connectormydb = mysql.connector.connect(  host="localhost", 
  user="yourusername",  password="yourpassword",  database="mydatabase")mycursor = 
  mydb.cursor()mycursor.execute("SELECT * FROM customers")
  myresult = mycursor.fetchall()for val_1 in myresult:  print(val_1)

Note: Note: We use the fetchall() method, which fetches all rows from the last executed statement.

Selecting Columns

To select only some of the columns in a table, use the "SELECT" statement followed by the column name(s):

python

import mysql.connectormydb = mysql.connector.connect(  host="localhost", 
  user="yourusername",  password="yourpassword",  database="mydatabase")
mycursor = mydb.cursor()mycursor.execute("SELECT name, 
  address FROM 
  customers")myresult = mycursor.fetchall()for val_1 in myresult:  
  print(val_1)

Using the fetchone() Method

If you are only interested in one row, you can use the fetchone() method.

The fetchone() method will return the first row of the result:

python

import mysql.connectormydb = mysql.connector.connect(  host="localhost",
   
  user="yourusername",  password="yourpassword",  database="mydatabase")mycursor = 
  mydb.cursor()mycursor.execute("SELECT * FROM customers")
  myresult = mycursor.fetchone()print(myresult)

Module quiz

Test your knowledge on this module

5 questions

MySQL Insert

MySQL Where

MySQL Select

AI Summary

Select From a Table

Selecting Columns

Using the fetchone() Method

Module quiz