Regarding:
I created some tables at the sqlite prompt using the terminal
window on a Mac. I checked with .tables and .schema and they were
created and I inserted data. I closed the terminal window and went back
later. At the sqlite prompt there were no tables. I tried .tables and
.schema and nothing.
So what happened to my tables?
--
Hi Janis,
Is it possible that when you ran sqlite from the command prompt, you did
not specify a filename for the database to be created?
If you run "sqlite3" with no file specified it will create a temporary
database in RAM memory.
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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
