#Sqlite for mac output code#
#Sqlite for mac output free#

It might be wise to name the database files with a file-ending of.This file can be named anything - the name doesn't change the contents of the file.The database is stored in a binary (non-text) file.2.12 Summary of what you should know after this session.2.11 Task 10 - Create a backup SQL text file using.

#Sqlite for mac output free#

2.10 Task 9 - Feel free to examine various commands.

2.9 Task 8 - Look at the books table contents.

2.8 Task 7 - Create an SQL text file with books.

2.7 Task 6 - Investigate the my_books database.

2.6 Task 5 - Enter your database in various ways.

2.5 Task 4 - Log out from the database and examine stuff.

2.4 Task 3 - Create a table in your newly created database.

2.3 Task 2 -Create a database called my_books.

2 Exercise for the Getting started with SQLite chapter.

vfsname ?AUX? Print the name of the VFS stackД¦2. vfsinfo ?AUX? Information about the top - level VFSД¦1. trace ?OPTIONS? Output each SQL statement as it is runДҐ9. timer on | off Turn SQL timer on or offДҐ8. timeout MS Try opening locked tables for MS millisecondsДҐ7. testcase NAME Begin redirecting output to 'testcase-out.txt' 56. tables ? TABLE ? List names of tables matching LIKE pattern TABLE 55. stats ? on | off? Show stats or turn stats on or offДҐ3. show Show the current values for various settingsДҐ2.

Compute a SHA3 hash of database contentДҐ0. separator COL ? ROW ? Change the column and row separatorsД¤8. selftest ?OPTIONS? Run tests defined in the SELFTEST table 47. schema ? PATTERN ? Show the CREATE statements matching PATTERN 46. scanstats on | off Turn sqlite3_stmt_scanstatus() metrics on or offД¤5. save FILE Write in - memory database into FILEД¤4. restore ?DB? FILE Restore content of DB ( default 'main') from FILEД¤3. progress N Invoke progress handler after every N opcodesДЈ9.prompt MAIN CONTINUE Replace the standard promptsД¤2. output ?FILE? Send output to FILE or stdout if FILE is omittedДЈ6. open ?OPTIONS?FILE? Close existing database and reopen FILEДЈ5. once ( - e | - x | FILE) Output for the next SQL command only to FILEДЈ4. nullvalue STRING Use STRING in place of NULL values 33. limit ?LIMIT?VAL? Display or change the value of an SQLITE_LIMITДў8.lint OPTIONS Report potential schema issues.Дў9.load FILE ?ENTRY? Load an extension libraryДЈ0. iotrace FILE Enable I / O diagnostic logging to FILEДў7. indexes ? TABLE ? Show names of indexesДў6. imposter INDEX TABLE Create imposter table TABLE on index INDEXДў5. import FILE TABLE Import data from FILE into TABLE 24. help ? - all ? PATTERN ? Show help text for PATTERN 23. headers on | off Turn display of headers on or offДў2. fullschema ? -indent? Show schema and the content of sqlite_stat tables 21.

#Sqlite for mac output code#

exit ?CODE? Exit this program with return - code CODEДЎ9. excel Display the output of next command in a spreadsheetДЎ8.

Enable or disable automatic EXPLAIN QUERY PLANДЎ7. echo on | off Turn command echo on or offДЎ6. dbinfo ?DB? Show status information about the databaseДЎ4. dbconfig ?op?val? List or change sqlite3_db_config() optionsДЎ3. databases List names and files of attached databasesДЎ2. clone NEWDB Clone data into NEWDB from the existing databaseДЎ1. changes on | off Show number of rows changed by SQL 9. cd DIRECTORY Change the working directory to DIRECTORYДЁ. binary on | off Turn binary output on or off. bail on | off Stop after hitting an error. backup ?DB? FILE Backup DB ( default 'main') to FILEДҐ. auth ON | OFF Show authorizer callbacksД¤.