Backup as Excel, CSV or MySQL table from Tkinter GUI data entry application

Описание: 00:00 Introduction
00:47 Importing libraries to create the backup script
01:26 decalring my_backup() function and adding the script to backup data
01:49 Using SQL to get data from SQLite database and creating pandas DataFrame by using read_sql()
04:18 Creating Excel file by using to_excel() from Pandas DataFrame
04:58 Creating CSV file by using to_csv() from Pandas DataFrame
06:42 Creating MySQL table by using to_sql() from Pandas DataFrame
10:19 Connecting the backup function my_backup() to main file by using button click event

#backup #DatabaseBackup #application #Tkinter #GUI

All source code here
https://www.plus2net.com/python/tkint...

Previous video
   • Tkinter & SQLite Data Entry Tutorial: Buil...  


Taking backup from our SQLite database data entry GUI to EXCEL, CSV or MySQL database. The script is connected to a Tkinter button.



Web site: www.plus2net.com
YouTube:    / @plus2net1  
Facebook:   / plus2net  
Instagram:   / plus2net.in  
LinkedIn:   / plus2net  
Write to us https: //www.plus2net.com/contactus.php