Tuesday, December 14, 2010

SQlite

Yesterday a successful day because I got introduce to this new program SQlite.
I run the program with (sqlite3) just to play around with it and after making some tables about Actors and Movies. After a while wondering how to get out of the program with out closing the terminal,
I try these commands :
exit
.exit;
but this won't work on SQlite. The right commands that will exit the program are (.quit),(.q), and (.exit) . Something new for me was that when you want to execute a command you need a dot at from of the command.

1 comment:

  1. The dot commands are used to control the sqlite3 command line interface (CLI). We won't be using them when we write web apps. We will instead access sqlite from python. For now, however, the CLI is the best way to learn sqlite.

    ReplyDelete