How to work with SQLite3 via command line?

Question

SQLite

I began to study SQLite3 and have not quite understood yet - is it possible in SQLite3 to work with the database completely referring to the program itself, i.e. sqlite3.exe (if in Windows), i.e. as I see from the documentation, working with sqlite3 is built next. way - the executable file is launched - sqlite3.exe, an invitation to enter SQL commands is opened, and then everything is done manually - entering and executing SQL commands, a description of all this is in the SQLite3 documentation, but I don’t see the opportunity to work with sqlite3 completely and immediately through the command line - that is, let's say I open the CMD console and enter - sqlite3 and immediately further a set of commands for working with the database and SQL commands, i.e. for example, so that such a line could be inserted into a bat file and automated thus. some database operations, is there such a possibility?

Answer 1

https://stackoverflow.com/a/31175038
sqlite3.exe test.db "select * from abc;" ".exit"