Delete All Database Record And Drop Table - Python Tkinter GUI Tutorial
In this video I'll show you how to delete everything from our Database Table with the DROP TABLE command.
The fastest and easiest way to delete all the records from our database table is to use the Drop Table Command.
Watch out though, this will permanently delete everything in the table, so we'll make a backup first!
After we delete all the records and drop the table, we'll need to recreate the table structure so that we can continue to add new customers in the future.
We'll also create a popup box that asks the user if they're sure they want to delete everything from the table.
#tkinter #codemy #JohnElder
Timecodes
0:00 - Introduction
0:58 - BackUp Database
2:20 - Connect To Database and Create Cursor
3:03 - Clear Entry Boxes
3:36 - Drop Table
6:29 - Create Popup Box Before Deleting
7:45 - Message Box Logic Yes/No
9:23 - Recreate Table After Dropping It
11:30 - Conclusion
On this page of the site you can watch the video online Delete All Database Record And Drop Table - Python Tkinter GUI Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Codemy.com 01 June 2021, share the link with friends and acquaintances, this video has already been watched 6,225 times on youtube and it was liked by 163 viewers. Enjoy your viewing!
