Forrest logo
back to context overview

sqlite-utils

List of commands for sqlite-utils:

  • sqlite-utils:tldr:28145 sqlite-utils: Show help information.
    $ sqlite-utils -h
    try on your machine
    explain this command
  • sqlite-utils:tldr:2c06e sqlite-utils: Select records.
    $ sqlite-utils rows ${path-to-database-db} ${table_name}
    try on your machine
    explain this command
  • sqlite-utils:tldr:7d08b sqlite-utils: Delete a record.
    $ sqlite-utils query ${path-to-database-db} "${delete from table_name where name = 'Tony Hoare'}"
    try on your machine
    explain this command
  • sqlite-utils:tldr:7ef66 sqlite-utils: Drop a table.
    $ sqlite-utils drop-table ${path-to-database-db} ${table_name}
    try on your machine
    explain this command
  • sqlite-utils:tldr:d64f0 sqlite-utils: Create a database.
    $ sqlite-utils create-database ${path-to-database-db}
    try on your machine
    explain this command
  • sqlite-utils:tldr:e01e5 sqlite-utils: Create a table.
    $ sqlite-utils create-table ${path-to-database-db} ${table_name} ${id integer name text height float photo blob --pk id}
    try on your machine
    explain this command
  • sqlite-utils:tldr:e53f8 sqlite-utils: List tables.
    $ sqlite-utils tables ${path-to-database-db}
    try on your machine
    explain this command
back to context overview