If you are using Sqlite3 to access the DB you would -0
sqlite3 harry.db3 //Creates a database called harry.db3
enter some SQL to create a table and populate it
exit
To retrieve your data
sqlite3 harry.db3 //Opens DB harry.db3
enter some SQL e.g.
SELECT * FROM mytab;
you will get the contents of the table.
exit
The DB harry.db3 will be a file called harry.db3 in your current
working directory.
sebcity wrote:
I created a table.
I populated the table.
I exited SQLite.
Started SQLIte again.
Typed "select * from <table name>".
ANd it tells me no such table exists??
Igor Tandetnik wrote:
sebcity <[EMAIL PROTECTED]> wrote:
Im new to SQLite, After you create your tables how do you save them
so they are permenently there? It might be a dumb question but i cant
find the answer anwhere?!
They are "permanently there" from the very moment you create them. All
changes are written to the database file when a transaction is
committed, or at the end of every statement if you don't open any
transactions explicitly.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
