Easy Steps for Python MySQL Database Connectivity [2023 ] | Setup & Queries (with MySQL Connector)

[@CSCORNERSunitaRai]

Got a question on this topic? Please share through comments or reach us on telegram t.me/cscorner Please SUBSCRIBE for more! Also, you can Support me through KZbin Thanks!

[@monogram_ad]

after using fetchall, we get all the stored values, plz tell after that how to get something like list1=[2, 'aditya'] kind of working, where list1 is a list and the values inside-> [ ] is obtained from the mysql connector, and that tuple maybe present at 2nd or 3rd row of the table.

[@CSCORNERSunitaRai]

Change sql query

[@Earningmaster2024]

You made it easy Others making it long and difficult explaination ❤thank you mam

[@RohitKumarMishra-f4c]

Mam can do it in mobile phone

[@CSCORNERSunitaRai]

I doubt

[@mayuranvn2511]

no u cant

[@nikitalodwal1973]

Mam yeh first data insert kiya h empty set bta rha tha fir apn ky kiya uske bas

[@Mrshanmugham1]

import mysql.connector as con ModuleNotFoundError: No module named 'mysql.connector'; 'mysql' is not a package - mysql.connector already installed Madam I cant understand why this error shows

[@CSCORNERSunitaRai]

Do u have multiple pathon installed? Set script folder path in environmental variable

[@Mrshanmugham1]

yes, working fine now Thanks LOT

[@RSanju_]

How to set a script folder path ma'am

[@taibaarain2000]

​@@CSCORNERSunitaRai mam In facing error again in idle python even after installing of mysql in command prompt please help me and make a video, and how to change path script to environmental variables please mam