In this section we will see how to create a table, inserting a value and deleting them from the table created. First we will see the code and will go with the explanation. Code Table Creation import mysql.connector cnx = mysql.connector.connect(user='root', password='Zoku&1236', host='localhost', d

We can split this section in 2 ways, Python Installation and MySQL Installation. Python Installation Depending upon the OS you use, you have to download appropriate package from this link https://www.python.org/ . Make sure you download the latest version and start the installer. Navigate to th

As we have created a database in our previous section, this section we will connect to that database using the python. Code import mysql.connector cnx = mysql.connector.connect(user='root', password='Zoku&1236', host='localhost', database='mermaid') print(cnx) cnx.close() Explanation First we need