![]() ![]() As such, they do not need to be terminated with a semi-colon). (In passing, any command starting with a full-stop are "internal" commands to the SQLite shell, and are not SQL statements. This will return you to the command-prompt. To get out, type and press ENTER (you'll get an error message of some kind: ignore it) then type. > prompt), so you are being prompted to enter the rest of the command, together with the terminating semi-colon. These commands can span multiple lines (hence the. any SQL statements given to the SQLite shell needs to be terminated with a semi-colon. Having said that, your problem is confusing a CMD command-line with an SQLite command-line (I've not looked at the tutorial, so I don't know if it's their fault for not making it clear enough :-)) any difficulties with the tutorial are probably best addressed to that site. Sorry, I am doing everything in DOS CMD and think I am doing it right, but in case you have not noticed, I am not a guru :-)įirst, to the best of my knowledge, that tutorial site has no official connection to "core" SQLite and this forum. Instruction: try a simple command like seeing the tablesĮrror: unable to open database "c:dbchinook.db": unable to open database file It says I should see a folder called sqlite> which I do Instruction: use the following command to connect to the chinook sample database located in the db folder, which is a subfolder of the sqlite folder. I am not quitting, and moving on to the next instructions to download and unzip the demo file called chinook.db Instruction: it tells you to quit and to download a GUI. Result is: a list of help commands / information similar to example help command from the sqlite> prompt to see all available commands in sqlite3. Use ".open FILENAME" to reopen on a persistent database. Result is (and it compares to the example):Ĭonnected to a transient in-memory database. ![]() Instruction is: type sqlite3 and press enter, you should see the following output Instruction is: type sqlite3 and press enter Instruction is: navigate to the C:sqlite folde ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |