Python & SQLite: Backup DB & Delete, Drop Table

preview_player
Показать описание
Welcome to another tutorial, this video is going to be about delete and drop query and also how to backup the SQLite DB through python code.

So why do we need to backup a DB?
During any kind of disaster, backups help to restore restore data after files have been destroyed or removed. Backups of DB are important for data loss prevention, which can fully interrupt business operations.

DELETE:
The DELETE statement is used to delete existing records in a table.

DROP:
The DROP TABLE statement is used to drop an existing table in a database.

(Affiliate Link, Helps the Channel)
Рекомендации по теме
Комментарии
Автор

thank you for the time you dedicated to do this tutorial! it helped me a lot!

TheEsteban