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.
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?
I included the education as well, but since it's positioned on the right-hand side, so its not visible. However, you can add it to your database table.
It’s there on the right side, but you might not see it! 😄 If you missed it and already created the table without the education column, just add this code after the CREATE TABLE line: cursor.execute('ALTER TABLE employee_data ADD COLUMN education VARCHAR(100) AFTER employment_type')
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 = self._read_query_result(unbuffered=unbuffered) ~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^ 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 = self.connection._read_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 err.raise_mysql_exception(self._data) ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^ 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>
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
Great. This time, it is dosed. Many handlings. Every Day, we learn a little more. Thanks so much
Welcome 😊
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.
Thank you very much 😊
Good Teacher
I really like the way you teach
Thanks
I have learn alot from this video Thanks
Great congratulations 👏
just finished he second part , time to start this one , thanks for sharing
Welcome.. hope you are learning
@@codinglifestyle4u yessir i am pausing , trying on my own , and then correcting with the video
Great all the best.
hi sir can you please tell about mysql installation and setup ive used mssql and workbench only
Check MySQL installation and uninstallation videos in my channel
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?
This is possible in case the row is not selected. How to resolve the problem
Mr Faizan you did not explain why you did not add 'EDUCATION ' to the database but it appears in the mysql database
I included the education as well, but since it's positioned on the right-hand side, so its not visible. However, you can add it to your database table.
@@codinglifestyle4u yes it works 👍
It’s there on the right side, but you might not see it! 😄
If you missed it and already created the table without the education column, just add this code after the CREATE TABLE line:
cursor.execute('ALTER TABLE employee_data
ADD COLUMN education VARCHAR(100) AFTER employment_type')
Brother, can i use sqlite 3
Yes you can
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 = self._read_query_result(unbuffered=unbuffered)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
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 = self.connection._read_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
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
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>
Recheck the code
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
Send me the error pic on instagram coding_lifestyle_4u
Sir cannot import name employee_form from employees
You have to write like this -
import employee_form from employees
Now, how to do own tkinter in python
I didn't get you please elaborate?
@@codinglifestyle4u I might Said it wrong, I mean't own graphical interface 👍
You will be able to create your own gui after learning one or two projects
@@codinglifestyle4u thank you! 🙂
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
i might add , a discord community or something similar for viewers , we can help eachothers and such , i bet it will be very active
Yes I am aware of that issue I will fix it in upcoming tutorials
@@codinglifestyle4u update , i just finished this part , to the next one
Great 👍
cursor.execute('CREATE DATABASE IF NOT EXISTS inventory_system')
^^^^^^
NameError: name 'cursor' is not defined
Please recheck the code you must be making mistake
@@codinglifestyle4u ok sir. thank you. i will recheck