Well I missed that in the doucmentation, thanks. I just re-read it. Although at the prompt I thought I did put test as the filename. Maybe I left off the .db? So this should be to get the prompt and save the fiel. sqlite3 test.db > Am I right that you can only have one database file per sqlite installation? So there is no way to change database files? Tia, On 3/21/08 6:47 AM, "Griggs, Donald" <[EMAIL PROTECTED]> wrote:
> 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 Janis -- <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash. cab#version=8,0,0,0" width="300" height="190" id="votd" align="middle"> <param name="allowScriptAccess" value="sameDomain" /> <param name="movie" value="http://www.biblegateway.com/usage/votd/votd.swf"; /> <param name="quality" value="high" /> <param name="bgcolor" value="#ffffff" /> <embed src="http://www.biblegateway.com/usage/votd/votd.swf"; quality="high" bgcolor="#ffffff" width="300" height="190" name="votd" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"; /> </object> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
