Peter, I think you're the perfect candidate for using one of the many sqlite gui admin tools out there. There are lots of them and they all do a good job of getting you off the ground when you are a newcomer to sqlite, but I have to shamelessly promote my own tool, SQLiteAdmin. I think it would have avoided many of your frustrations.
You can download it at www.lcsql.com/sqliteadmin.html. Some functionality is disabled in the demo but you can create a new database from the File menu and import a csv file in the Utilities screen. Pete lcSQL Software <http://www.lcsql.com> On Tue, May 8, 2012 at 9:00 AM, <[email protected]> wrote: > Message: 18 > Date: Mon, 7 May 2012 19:34:19 -0400 > From: "peter korinis" <[email protected]> > To: <[email protected]> > Subject: Re: [sqlite] is SQLite the right tool to analyze a 44GB file > Message-ID: <[email protected]> > Content-Type: text/plain; charset="us-ascii" > > I did NOT specify a file name when I started sqlite3 - so I guess all is > lost. I'll have to redo it. > > So then the first thing is to specify the db (file) name - what syntax? I > tried typing a file name (test.db) but error. > > > > pk > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
