Delete All Database Record And Drop Table - Python Tkinter GUI Tutorial

Опубликовано: 01 Июнь 2021
на канале: Codemy.com
6,225
163

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


На этой странице сайта вы можете посмотреть видео онлайн Delete All Database Record And Drop Table - Python Tkinter GUI Tutorial длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Codemy.com 01 Июнь 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 6,225 раз и оно понравилось 163 зрителям. Приятного просмотра!