Hi, Milton,

Regarding: The command "sqlite3 test.db" and "sqlite3 ex1" ....

You're referring the to command line test program, "sqlite3" or
"sqlite3.exe".

These commands will create databases named "test.db" and "ex1"
respectively, if they did not exist before you ran the command.   Of
course, they will be empty of data until you create and load tables.

You exit the command line program with "period quit"
    .quit
However, if the program believes you are in the middle of entering a
long command, you may need to terminate the sql first by typing a single
semicolon, then pressing RETURN
     ;
     .quit
I've indented these for clarity, but you'll want to be sure the ".quit"
has the period in the first column.   

Another useful "dot command" is
      .help


This email and any attachments have been scanned for known viruses using 
multiple scanners. We believe that this email and any attachments are virus 
free, however the recipient must take full responsibility for virus checking. 
This email message is intended for the named recipient only. It may be 
privileged and/or confidential. If you are not the named recipient of this 
email please notify us immediately and do not copy it or use it for any 
purpose, nor disclose its contents to any other person.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to