Python – Creating a MySQL Database
In Python, the “CREATE DATABASE” statement is used to create a MySQL database.
Python – Connecting to a MySQL Database
Python can be used in database applications to connect to a MySQL database to interact with stored information.
Python – Creating a MySQL Table
In Python, the “CREATE TABLE” statement is used to create a MySQL table.
Python – Adding Data to a MySQL Table
In Python, the “INSERT INTO” statement is used to add data to a MySQL table.
Python – Retrieving Data From a MySQL Table
In Python, the “SELECT” statement is used to get data from a MySQL table.
Python – Using “WHERE” to Retrieve Data From a MySQL Table
In Python, the “WHERE” statement is used to get filtered data from a MySQL table.
Python – Using “ORDER BY” to Order Data From a MySQL Table
In Python, the ORDER BY keyword is used to sort the resulting data in either ascending or descending order.
Python – Using “LIMIT” When Retrieving Data From a MySQL Table
In Python, the “LIMIT” statement is used to limit the number of records returned from a MySQL table.
Python – Updating Data in a MySQL Table
In Python, the “UPDATE” statement is used to make changes to existing data in a MySQL table.
Python – Deleting Data From a MySQL Table
In Python, the “DELETE FROM” statement is used to remove data from a MySQL table.
Python – Joining Two or More MySQL Tables
In Python, the “JOIN” statement is used to combine rows from two or more tables, based on a related column they share.