Este grupo de expertos pasados algunos días de trabajo y de juntar de datos, obtuvimos la respuesta, queremos que te sea de gran utilidad en tu plan.
Ejemplo 1: sqlite rellena la base de datos desde el shell de comandos de archivo
sqlite3 test.db
sqlite3>.readcreate-tables.sqlEjemplo 2: lista de comandos sqlite
sqlite>.help
.archive ... Manage SQL archives
.auth ON|OFFShow authorizer callbacks
.backup ?DB? FILEBackup DB (default"main")toFILE.bail on|off Stop after hitting an error.DefaultOFF.binaryon|off Turn binary output onoroff.DefaultOFF.cd DIRECTORY Change the working directory to DIRECTORY
.changes on|offShow number ofrows changed bySQL.check GLOB Fail if output since .testcase does notmatch.clone NEWDB Clone datainto NEWDB from the existing database.databases List names and files of attached databases.dbconfig ?op? ?val? List or change sqlite3_db_config() options
.dbinfo ?DB? Showstatus information about the database.dump ?TABLE? ... Render alldatabase content asSQL.echo on|off Turn command echo onoroff.eqp on|off|full|...Enableordisable automatic EXPLAIN QUERY PLAN.excel Display the output ofnext command in a spreadsheet
.exit ?CODE? Exit this program withreturn-code CODE
.expert EXPERIMENTAL. Suggest indexes for specified queries
.fullschema ?--indent? Show schema and the content of sqlite_stat tables.headers on|off Turn display of headers onoroff.help ?-all? ?PATTERN? Show help textfor PATTERN
.importFILETABLEImportdatafromFILEintoTABLE.imposter INDEXTABLECreate imposter tableTABLEonindexINDEX.indexes ?TABLE? Show names of indexes
.iotrace FILEEnable I/O diagnostic logging toFILE.limit ?LIMIT? ?VAL? Display or change the valueof an SQLITE_LIMIT
.lint OPTIONS Report potential schema issues..loadFILE ?ENTRY? Load an extension library
.log FILE|off Turn logging onoroff.FILE can be stderr/stdout
.modeMODE ?TABLE? Set output mode.nullvalue STRING Use STRING in place ofNULLvalues.once (-e|-x|FILE) Output for the nextSQL command only toFILE.open ?OPTIONS? ?FILE? Close existing databaseand reopen FILE.output ?FILE? Send output toFILEor stdout ifFILEis omitted
.parameter CMD ... Manage SQL parameter bindings
.print STRING...Print literal STRING
.progress N Invoke progress handlerafter every N opcodes
.prompt MAIN CONTINUEReplace the standard prompts
.quit Exit this program
.readFILERead input fromFILE.restore ?DB? FILERestore content of DB (default"main")fromFILE.saveFILEWritein-memory databaseintoFILE.scanstats on|off Turn sqlite3_stmt_scanstatus() metrics onoroff.schema ?PATTERN? Show the CREATE statements matching PATTERN
.selftest ?OPTIONS? Run tests defined in the SELFTEST table.separator COL ?ROW? Change the columnandrow separators
.session ?NAME? CMD ...Createor control sessions
.sha3sum ...Compute a SHA3 hashofdatabase content
.shell CMD ARGS... Run CMD ARGS...in a system shell
.showShow the currentvaluesfor various settings
.stats ?on|off? Show stats or turn stats onoroff.system CMD ARGS... Run CMD ARGS...in a system shell
.tables ?TABLE? List names oftables matching LIKE pattern TABLE.testcase NAME Begin redirecting output to'testcase-out.txt'.timeout MS Try opening locked tablesfor MS milliseconds
.timer on|off Turn SQL timer onoroff.trace ?OPTIONS? Output each SQL statement as it is run
.vfsinfo ?AUX? Information about the top-level VFS
.vfslist List all available VFSes
.vfsname ?AUX? Print the name of the VFS stack
.width NUM1 NUM2 ...Setcolumn widths for"column"mode
sqlite>Aquí puedes ver las comentarios y valoraciones de los lectores
Nos encantaría que puedieras dar difusión a este post si si solucionó tu problema.
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)