3. Inventory Management System with Python Tkinter & MySQL: Database Integration & CRUD Operations

In Part 3 of our Inventory Management System tutorial, we’ll show you how to connect your Python Tkinter app to a MySQL database. You'll learn how to add, update, delete, search, and display data step by step.

Like & Subscribe for upcoming tutorials.

Complete Source Code:

For any query -
👉 Instagram: @coding_lifestyle_4u

⏱️ Timestamps:
- 0:00 - Introduction & Overview
- 0:57 - Code Formatting
- 6:40 - Database Connection
- 16:28 - Add Button Implementation
- 41:27 - Clear Button Implementation
- 56:28 - Update Button Implementation
- 1:31:02 - Delete Button Implementation
- 1:40:10 - Search Button Implementation
- 1:57:20 - Show All Button Implementation
- 2:00:00 - Conclusion

#tkinter #tkintertutorial #pythonprojects #inventorymanagementsoftware #inventorysystem #pythonguitutorial #pythongui #pythonmysql #mysqlproject #pythonforbeginners #pythontkinter #python

[HenrySuikaM]

You're a wonderful teacher and I have learnt a lot from you, a big thank you. I was able to follow through while implementing all the steps using MS SQL Server Express.

[soumahorosoualiho]

Great. This time, it is dosed. Many handlings. Every Day, we learn a little more. Thanks so much

[AbdulaiMoro-tdxm]

Good Teacher
I really like the way you teach

[freesoftwares]

just finished he second part, time to start this one, thanks for sharing

[The.Ride.Report]

I have learn alot from this video Thanks

[AbdulaiMoro-tdxm]

Mr Faizan you did not explain why you did not add 'EDUCATION ' to the database but it appears in the mysql database

[Useme-es]

hi sir can you please tell about mysql installation and setup ive used mssql and workbench only

[soumahorosoualiho]

Hi Coach. Thank you for all. I noticed that when we select a row to be updated, only one item can be updated. It's not possible to update many items at the same time. This is due to the fact that the row is selected. Can you see this issue?

[wissembabaami]

hi please i cant insert into table i dont know why :


File "c:\Users\wiwy\Desktop\mon 2eme projet\employer.py", line 46, in valide_employer
cursor.execute('INSERT INTO employers VALUES(%s)', (empid))

File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 153, in execute
result = self._query(query)
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\cursors.py", line 322, in _query
conn.query(q)

File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 563, in query
self._affected_rows =

File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result
result.read()

File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 1199, in read
first_packet =
File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet
packet.raise_for_error()

File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error


File "C:\Users\wiwy\AppData\Local\Programs\Python\Python313\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1136, "Column count doesn't match value count at row 1")
PS C:\Users\wiwy\Desktop\mon 2eme projet>

[autarroy]

brother, if i am clicking on the command to see the database is not showing me the employee_data. What is going wrong.
How i can use mysql or how i can download it

[Secondbrain]

Sir cannot import name employee_form from employees

[freesoftwares]

i think i found a bug, anyways, if you click on the employee button WHILE you are in that page already, the back button wont work anymore

[ahmedjawad]

cursor.execute('CREATE DATABASE IF NOT EXISTS inventory_system')

NameError: name 'cursor' is not defined