PySide6 GUI and MySQL Full Course | ADD, UPDATE, RETRIEVE & DELETE FUNCTIONS (2023)

In this video i will show you how to add, update and delete content from MySQL Tables and how to retrieve them and display on QTableWidget using PySige6 GUI. Its easy. Watch and learn.
We shall be using XAMPP server for the mySQL database. We shall also be using visual studio code to write our python code. When we retrieve the information from the tables we shall load it and display in QTableWidget class.
00:00 Introduction to video
03:02 Install MySql Connector
07:49 Create connection to MySql Database
08:39 Add Widgets to the GUI
18:06 Insert Demo List Data to MySql Database table
21:35 Retrieve Data from MySql Database table
24:13 Add new row to MySql Database table
29:47 Update row in MySql Database table
36:10 Delete row in MySQl Database table

[@davethinkingsystems]

I can't believe how good your content is. Its rapid and consice. I'm learning loads, thanks for creating this.

[@davethinkingsystems]

I've now gone through this and refactored it into operate with my SqlAlchemy based database. Thanks so much, you have really helped me out with this.

[@jeremiassoll1837]

This tutorial is really nice! Thanks for sharing.
I See a problem in your update function. When you set your command to "UPDATE employees_list SET [...] WHERE %s), new_values" it updates not only a single name, but everywhere in the table that actually has a segment of the list. That might lead to difficulties when you have a lot of similar names like when you need to put in color names or for example if someone shares the same age. Just for info. The lesson is perfect for me as a beginner :)

[@anthonywelcher5036]

Tbh man, you’re prolly the only UX design YTer I like. No did to the other creators, but idk you’re just cool. Mean that sincerely. Hopefully one day I will have skill