Notas de Luis

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;
computing/databases/sqlite.txt · Última modificación: por 127.0.0.1