We use cursor to operate on query result in MySQL.
Next, in order to be able to fetch data of pythondatabase, we have created a cursor() method too.
Initially, we have imported pymysql to establish a connection by using nnect() method which takes four arguments: # make a habit to close the database connection once you create it #Make sure to initiate the cursor to fetch rows Once, you have created the database, simply move to your python IDE and import pymysql in order to build connection with MySQL. Once the servers have started, go to your browser and go to this address: You will see a phpmyAdmin dashboard, now create a new database and name it as pythondatabase. Once you have installed MAMP, simply open it and start the server, your MAMP should look like this: If you already have MySQL installed then you can move on to the other step. We have already installed MAMP server for our database, you can install MAMP here. Note: Your python folder location could be different than mine. Make sure you have an active internet connection to complete the steps. Once you are inside the directory after entering cd and pasting the filepath where your python scripts folder is located next step is to enter pip install pymysql as shown below: Next you have to open the command prompt and enter the following command: cd C:\Users\Hira\AppData\Local\Programs\Python\Python37-32\Scripts To install mysql package do the following: go to the Scripts directory in the python and copy the file path: C:\Users\Hira\AppData\Local\Programs\Python\Python37-32\Scripts For example, the directory location on my system looks like this: First of all we have to install python mysql connector package. To install this connector we need to go inside the ‘python’ official directory and find the scripts folder. In order to connect Python to a database we need to have a mysql connecter package installed.
0 kommentar(er)
