Python Database Connectivity(Using Xampp and PyCharm)Performing database queries using python code.

preview_player
Показать описание
There are the following steps to connect a python application to nour database.

Create the connection object.

Create the cursor object.

Execute the query.

Install PyCharm and Xampp
Install mysql-connector and ConnectorDB python library packages.

In PyCharm Go to File--Settings--PythonProject--Interpreter--In search bar type package name.

Write the program to Connect to the database.

In Xampp Control Panel,
Start the Mysql and Apache Server.Then go to Admin button in front of Mysql.Then in webpage opens named PhpMyAdmin create your database following the steps shown in the video.

Please subscribe my channel for more project ideas and more educational videos.
Рекомендации по теме
Комментарии
Автор

How can I delete or update the information on pycharm if I use mysql to store users data

reemahud
Автор

Mam it show attribute error-showing pymyql has no attribute connect
Plz tell me what I do

Gudu
Автор

do you have a tutorial of crud using xampp and pycharm like this vid.

marvenlayron
Автор

in xampp control panel Admin in front of MySql is not accessible and it is not getting start rather showing problem as it is not connecting to 3306 port

s.s.s
Автор

I'm getting an error in SQL Syntax when I try to save.

samiulhuda