Python Tutorials: Database operations using python - mysql

Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours scrolling social media and waste money on things we forget, but won’t spend 30 minutes a day earning certifications that can change our lives.
Master in DevOps, SRE, DevSecOps & MLOps by DevOpsSchool!

Learn from Guru Rajesh Kumar and double your salary in just one year.

Step 1 – Install MYSQL Server

https://www.devopsschool.com/blog/how-to-download-and-install-mysql-in-macos-10/
https://www.devopsschool.com/tutorial/mysql/how-to-install-mysql-on-centos-7.html

Step 2 – Install python mysql connector using PIP3

$ sudo pip3 install mysql-connector-python

Step 3 – Using Python – Check a mysql Connection

Step 4 – Using Python – Create a database

Step 5 – Using Python – Create a Table

Step 6 – Using Python – Insert Row Ops

Step 7 – Using Python – Read Row Ops

Step 8 – Using Python – Update Row Ops

Step 9 – Using Python – Delete Row Ops

Rajesh Kumar

I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.

Do you want to learn Quantum Computing?

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs: