>.help .--------------------------- | .add - adds new database to the list | .cd - changes current working directory | .close - closes given (or current) database | .databases - prints list of registered databases | .dblist - prints list of registered databases | .desc - shows details about the table | .dir - lists directories and files in current working directory | .exit - quits the application | .help - shows this help message | .history - prints history or erases it | .ls - lists directories and files in current working directory | .mode - tells or changes the query results format | .null - tells or changes the NULL representation string | .nullvalue - tells or changes the NULL representation string | .open - opens database connection | .pwd - prints the current working directory | .query - executes SQL query | .quit - quits the application | .remove - removes database from the list | .tables - prints list of tables in the database | .tree - prints all objects in the database as a tree | .use - changes default working database `--------------------------- .--------------------------- | Usage: .help [] | | Use .help to learn about certain commands supported by the command line interface (CLI) of the SQLiteStudio. | To see list of supported commands, type .help without any arguments. | | When passing name, you can skip special prefix character ('.'). | | You can always execute any command with exactly single '--help' option to see help for that command. It's an | alternative for typing: .help . `--------------------------- To read SQL commands from a file: Example: already existing empty database test5 with 1. Create a file (eg. test5.sql) like this: .use test5 ..... lots of SQL commands..... .exit Run by typing sqlitestudiocli < test5.sql