Tabla de Contenidos
Sqlite
Ayuda de sqlite
bail ON OFF :Stop after hitting an error. Default OFF databases :List names and files of attached databases dump ?TABLE? ... :Dump the database in an SQL text format .echo ON OFF :Turn command echo on or off .exit : Exit this program .explain ON OFF : Turn output mode suitable for EXPLAIN on or off. .header(s) ON OFF : Turn display of headers on or off .help : Show this message .import FILE TABLE : Import data from FILE into TABLE .indices TABLE : Show names of all indices on TABLE .mode MODE ?TABLE? : Set output mode where MODE is one of : csv : Comma-separated values column : Left-aligned columns. (See .width) html : HTML <table> code insert : SQL insert statements for TABLE line : One value per line list : Values delimited by .separator string tabs : Tab-separated values tcl : TCL list elements .nullvalue STRING : Print STRING in place of NULL values .output FILENAME : Send output to FILENAME .output stdout : Send output to the screen .prompt MAIN CONTINUE : Replace the standard prompts .quit : Exit this program .read FILENAME : Execute SQL in FILENAME .schema ?TABLE? : Show the CREATE statements .separator STRING : Change separator used by output mode and .import .show : Show the current values for various settings .tables ?PATTERN? : List names of tables matching a LIKE pattern .timeout MS : Try opening locked tables for MS milliseconds .timer ON OFF : Turn the CPU timer measurement on or off .width NUM NUM ... : Set column widths for 'column' mode
Averiguar tamaños de tablas
PRAGMA page_size; select * from sqlite_master;
El numero de pagina es acumulativo. Se resta el valor anterior y se multiplica por page\_size para obtener el tamano en bytes
Cuantos cambios en el ultimo insert/update/delete
select changes() from TABLE;