SQLITE + problems saving tables
hey all, i am a newbie to SQL, and decided to start with SQLITE3. I am learning commands and manipulating data in a table. HOwever every time i .quit sqlite and open again, any new table i have just made is not saved?? DO i understand that sqlite should execute the transaction commands by itself (begin, commit).
i downloaded sqlite-3.1.6.tar.gz, unziped, configure, make && makeinstall
with no problems
WHen i run i can enter data into a table but does not save.
i have tried to open sqlite3 like so:
$ ./sqlite3 testdb
but when i try to create a table i get the error:
Unable to open database "testdb": unable to open database file
$ ./sqlite // this works, but again .tables shows nothing after .quit