Accessing MySQL Database using Python | using mysql-connector-python | SuMyPyLab

Accessing MySQL Database using Python using mysql-connector-python. In this lesson you will learn -
0:28 Installation of mysql-connector-python module
0:42 Table Description
1:14 Connecting to MySQL server
2:50 Select query
4:51 Insert Records
6:59 Update Records
7:58 Record Insert (another approach)
9:04 Insert Data from Dictionary
10:47 Insert multiple rows
12:21 Delete records
13:18 Creating database and tables
Other lessons in this series:
Other lesson in this series:
• Seaborn Pairplot | Sea...
• Data Visualization usi...
• Python SQLAlchemy ORM ...
• CSV file to MySQL and ...
• Python MySQL SQLAlchem...
• Python MySQL Pandas Ma...
• Accessing MySQL Databa...
• Accessing MySQL Databa...
installation of MySQL connector python
#datascience
#dataanalysis
#dataanalytics
#mysql

[@hariprasad-zq2bp]

Where is exception handling

[@SuMyPyLab]

To make the introduction simple for a beginner, I intentionally did not handled exceptions. Exception handling is covered in my next lesson. Please watch that lesson. The link is given below:
czcams.com/video/kRtGYKOI6HI/video.html