34 PyQt5 Inserting Data To Mysql Database CRUD Application

Join My PyQt6 13 Hours Course in Udemy

This is our thirty fourth video in pyqt5 gui programming,
in this video we are going to cover how you can insert data into
mysql database, we are using wamp server for our database purposes
and for connection we are using mysqlclient package of python

for mysqlclient installation just use
pip install mysqclclient

PyQt5 Database Connection Video

PyQt5 Complete Playlist From Beginners To Intermediate

[KarakalLatino]

Yes, yes, yes, from now you are my Python Teacher, you really know how to do, God bless you, please i would like to contact you for personal class on line, thanks, thanks.

[Minecrafterlein]

Hi Parwiz, i'm looking your vids since some days and it is wunderfull. You explaine the things very well! Thanks for that. I have a question too: If i want to put datas from a QTablewidget in a database, does it work like your excample?
Thanks for all!

[oscaralba]

Hi Parwiz. I current use python 3.7 which import "mysql.connector" module. The exercise of db conecction (video 33) run OK. But with this excercise (video 34) there is a reiterative error:
"with con:
AttributeError: __enter__". ???

[ranzvannllido]

what is the 'self' for? i am new in python

[pragatigupta]

when i enter the input my window is stopped working.please tell me what i do

[ruturajsarnobat]

Hi Parwiz, I got an error for "con" as "with con: AttributeError: __enter__". How can I solve this error??

[oscaralba]

How could we prevent (or do) a messagebox, for a duplicate data entry error for a primary key variable ??. The error message is:

(1062, "Duplicate entry '1234..' for key 'PRIMARY'")

[malavikahari]

From where would I access the code that you just copied for MyWindows.py? Thank You

[casmototech-cristoveradisa]

hi, my syntax is invalid. in my "join" is red when it run in idle. how should i do now? please me :(

[DerpRenz]

in my sql command line, everything shows the same except the ID which says null. I don't know why.

[maheenfatima]

I used your exact code. when i used pymysql it showed "with con: AttributeError: __enter__". with MySQLdb it shows the message that data is inserted but when i look in phpmyadmin, there is no entry.

[abdulrafay]

I am doing it the same way in SQLite3 it is working perfectly no errors but the database isnt updating. any solutions?

[KarakalLatino]

The title of the video say CRUD and you only did Insert, thanks