Python script to obtain data from a database (SQLITE)
How are the number of tables, number of columns, rows and data in each table, and the number of total records
Write the name of the database and get some of its data
Script de Python para obtener los datos de una base de datos (SQLITE)
Como son el numero de tablas, numero de columna, filas y datos de cada tabla, y el numero de registros totales
Escribe el nombre de la base de datos y obten algunos de sus datos
EXAMPLE
The database has 12 tables
The tables android_metadata has 1 columns, 1 rows and 1 registers
The tables sport_summary has 8 columns, 205 rows and 1640 registers
The tables location_data has 13 columns, 177949 rows and 2313337 registers
The tables running_info_per_km has 11 columns, 1276 rows and 14036 registers
The tables heart_rate has 14 columns, 797587 rows and 11166218 registers
The tables request has 4 columns, 4 rows and 16 registers
The tables medal has 2 columns, 0 rows and 0 registers
The tables running_info_per_lap has 23 columns, 907 rows and 20861 registers
The tables cadence_detail has 7 columns, 0 rows and 0 registers
The tables sport_tha_info has 16 columns, 732 rows and 11712 registers
The tables daily_perpormance_info has 6 columns, 1999 rows and 11994 registers
The tables vo2_max_day_info has 5 columns, 172 rows and 860 registers
The database sport_data.db has 13540675 dates