• 【原创】数据库基础之Sqlite


    官方:https://www.sqlite.org/index.html

    简介

    SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.

    The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through at least the year 2050. SQLite database files are commonly used as containers to transfer rich content between systems and as a long-term archival format for data. There are over 1 trillion (1e12) SQLite databases in active use.

    安装

    # yum install sqlite-devel

    使用

    # sqlite3 -version
    
    # sqlite3 /path/to/db
    
    sqlite>.database
    
    sqlite>.schema
    
    sqlite>.schema table_name
    
    sqlite>insert/delete/select/update

    sqlite>.exit

    sqlite>.quit

    sqlite> .help
    .backup ?DB? FILE Backup DB (default "main") to FILE
    .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
    If TABLE specified, only dump tables matching
    LIKE pattern TABLE.
    .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.
    With no args, it turns EXPLAIN on.
    .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
    If TABLE specified, only show indices for tables
    matching LIKE pattern TABLE.
    .load FILE ?ENTRY? Load an extension library
    .log FILE|off Turn logging on or off. FILE can be stderr/stdout
    .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 Use STRING in place of NULL values
    .output FILENAME Send output to FILENAME
    .output stdout Send output to the screen
    .print STRING... Print literal STRING
    .prompt MAIN CONTINUE Replace the standard prompts
    .quit Exit this program
    .read FILENAME Execute SQL in FILENAME
    .restore ?DB? FILE Restore content of DB (default "main") from FILE
    .schema ?TABLE? Show the CREATE statements
    If TABLE specified, only show tables matching
    LIKE pattern TABLE.
    .separator STRING Change separator used by output mode and .import
    .show Show the current values for various settings
    .stats ON|OFF Turn stats on or off
    .tables ?TABLE? List names of tables
    If TABLE specified, only list tables matching
    LIKE pattern TABLE.
    .timeout MS Try opening locked tables for MS milliseconds
    .trace FILE|off Output each SQL statement as it is run
    .vfsname ?AUX? Print the name of the VFS stack
    .width NUM1 NUM2 ... Set column widths for "column" mode
    .timer ON|OFF Turn the CPU timer measurement on or off

  • 相关阅读:
    Flask 5 模板1
    Flask 4 拓展
    Python学习札记(二十四) 函数式编程5 返回函数
    Python学习札记(二十三) 函数式编程4 sorted
    Docker:Err http://archive.ubuntu.com trusty InRelease & E: Unable to locate package [name] 问题
    解决 docker: Error response from daemon: ... : net/http: TLS handshake timeout.
    Ubuntu 安装Docker
    Flask 3 程序的基本结构2
    Flask 2 程序的基本结构1
    Flask 1 Introductory Chapter
  • 原文地址:https://www.cnblogs.com/barneywill/p/11058653.html
Copyright © 2020-2023  润新知