Python MySQL Database Connectivity | Sinhala

Python MySQL Database Connectivity | Sinhala
To create a connection between the MySQL database and Python, the connect() method of MySQL. connector module is used.

▬▬▬▬▬▬ T I M E S T A M P S ⏰ ▬▬▬▬▬▬
00:00 Introduction
02:09 Build Connection
07:00 Create table
08:50 Insert operation
10:22 Read operation
11:37 Delete operation
12:28 Update operation
13:20 Drop table

▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬

▬▬▬▬▬▬ Connect with me 👋 ▬▬▬▬▬▬

#programming
#sinhala
#codeprolk

[sajithsampath]

If you get error in 4:14,

Basiclly, You need to add the path of your pip installation to your PATH system variable.

First Option

Download pip by modifying the Pyton Installation.

Step 1 - Open Apps & Features

Step 2 - Find Python and click on it

Step 3 - Press Modify

Step 4 - Select pip

Step 5 - Select Add Python to environment variables and install everything

This will install pip and add both, Python and pip to your envirnoment variables.

Second Option

By default, pip is installed in C:\Python34\Scripts\pip

To add the path of your pip installation to your PATH variable follow theese steps.

Step 1 - Search for environment variables and open Edit the system environment variables

Step 2 - Open Environment Variables...

Step 3 - Find your PATH variable and select Edit

Step 4 - Paste the location to your pip installation (By default, it's C:\Python34\Scripts\pip) ~from stack overflow~

[dasundhananjaya]

මං දැකපු හොඳම සිංහල coading educational channel එක මම හිතන්නෙ මේක.මම ලොකු ගේමක් ගහගත්ත මේකෙ python tutorial එකෙන්. thank you so much bro

[dineshgamage]

මචන් සුපිරි කිරක් උඹ ඈ.... ගොඩාක් පින් උඹට....!!! තෙරුවන් සරණයි...!!!

[vibashini]

You're doing a 👍, keep it up 💪, I got a error saying, in finally, the connection is not defined, why's that 7:52

[RaveenHiruksha]

සර් මං 2024 ALකරන කෙනෙක් මට python පාඩම අමාරු වෙලා තිබ්බෙ දැං මට සර් අනිත් ඔක්කොටම වැඩිය ඒ පාඩම පුලුවං මේ කරන උදව්වට ගොඩාක් පිං සර් පුලුවන් නම් html, php, mysql ටිකත් මේ විදිහට කරන්න බැද සර්

[raveenhansaka]

Bro, Python SQL mula idalama thiyena widihata playlist ekak hadannako. Workbench eka install karana eke idala. oyage DB gana thibba playlist eka baluwa. mata hoyagnna ganna baruwada danna.

[saumyakasun]

my sql import karnna ba.moaka karanna ona

[thushankalana]

Aiye sql wala sum function ekaka value ekak java text box ekata hari msg box ekakata hari ganne kohomada.

[samithalowe]

bro flask gana video seris ekak dannako

[thushankalana]

Aiye mn HNDIT student kenek. Mn java walin system ekak hadana gaman inne. Ape project ekak. Mt eka hadan yaddi podi problems wagayak thiyanawa. Ewata solutions aiyagen ahaganna pluwan nm hodai. Contact karaganna number ekak denna puluwanda aiye.

[Flavoursofceylone]

ඇ අයියේ අයියා ඔතන commit කරන්න කලින් error එක mention කරත් ඇයි ඒ error එක display උන්.නැත්තේ..🙄🙄🤔