Create a Database and Table for our CRM - Python Tkinter GUI Tutorial #29

In this video we'll create the actual database for our CRM project. We'll also start to build out the table where we'll store most of the information that we want to collect about our customers.

To do most MySQL things in tKinter with Python, we need to create a cursor. The cursor is what we use to send commands to the database and get results.

After we create a cursor instance, we can use it to create a database and a table.

[mohamedelmabrouki]

you are a blessing to all beginners programmers .thank you sir from the bottom of my heart for your noble work. your videos helped me a lot

[Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:
Take $22 off with coupon code: youtube

[vladimirpajovic]

Best tutorial on internet. Great job. I learn a lot of things from you. Thank you very much. One thing, you can use CREATE TABLE IF NOT EXISTS to not create every time table. Same case for database. CREATE DATABASE IF NOT EXISTS.

[DP-xzcc]

Two small suggestions for people who start to learn coding: In my case it was neccessary to set use_pure=True for the mysql.connector and pass buffered=True for the cursor. It is i guess mandatory for the current version of a MySQL server installation.

[DifferentThinker]

i've created a database management tool using tkinter and my sql... and i developed it by watching your all the videos...😍😍😍😍😍😍now i want to make it executable but i dont know how to do it, can you pls make a video to show us how to make executable programme that supports mysql..😁😁😍😍😍😍😍😍

[QpsKart]

suppose i have saved all invoice data into .db but i want to edit specific invoice no but any invoice no is repeated because of many products rows how to achieve edit option by coding python gui thinker

[dennismartin]

You can use triple quotes to use multiple lines for a command or comments. ("""your code or comment""", or '''your code or comment''')

[TechWithSabri]

thank you so much sir for your videos

i watched all your videos but i have one note



try to build your projects for us using OOP of python please to understand in the same time all the concepts from you

And i want to know if there are any videos after this play list about python GUI + DataBase ?


by the way thnks a lot of for your hard work and for your gold time Love you man you are the best

[saikrishnadas]

Hey, I'm just curious to know if Tkinter has a code management technique? Because I feel writing so much of code into a single file feels messy and later it is hard to find and replace things. Any suggestions for this?

[noname]

Why it's always tell me that I have to download mysql despite I have downloaded it? And if I run the program I had "no module named 'mysql'"?

[mohammedkamran]

Sir can I use sqlite3 instead of MySQL, can I perform the same operations with sqlite3 as MySQL??

[amirnhosseinnavazi]

i have a error
1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
And you replied try two other connectors which two others exactly?

[f-tiergamer]

i have been digging youre video's. good stuff. i watch the one using config to change values.. but how would you make a tkinter app that updates itself regularly without user initiated events

[ShahinRzayevNergiz]

in my case it did not connect to MySQL and returned an error:
1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"
Any suggestions?

[salilchandan]

Please Tell me how to show the table data in Tkinter

[EverythingRox]

You look like Walter White from breaking bad lol