Connecting to MySQL Server

Installation

To install the Python-mysql-connector module, one must have Python and PIP, preinstalled on their system. If Python and pip are already installed type the below command in the terminal....

Connecting to MySQL Server

We can connect to the MySQL server using the connect() method....

Creating Database

...

Creating Tables

After connecting to the MySQL server let’s see how to create a MySQL database using Python. For this, we will first create a cursor() object and will then pass the SQL command as a string to the execute() method. The SQL command to create a database is –...

Insert Data into Tables

...

Fetching Data

For creating tables we will follow the similar approach of writing the SQL commands as strings and then passing it to the execute() method of the cursor object. SQL command for creating a table is –...

Update Data

...

Delete Data from Table

To insert data into the MySQL table Insert into query is used....

Drop Tables

...

Python MySQL Exercises

...

Python MySQL Applications and Projects

We can use the select query on the MySQL tables in the following ways –...