Sorry but could you show me the exact code to create a table that will be permenently there?
Griggs, Donald wrote: > > Regarding: > sebcity <[EMAIL PROTECTED]> wrote: >> ... After you create your tables how do you save them so >> they are permenently there? > > And Igor T's reply: > 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. > > However, if you are using the command shell for sqlite, you must provide > the name of your database file (even a new filename) when you invoke it. > Otherwise, the tables are created in volatile RAM. > E.g. > > sqlite Mydata.db > instead of just > Sqlite > > Regarding storing MP3 data: > One answer might be: Yes, you can use BLOBs, but you may be better > off using SQLITE just to *index* existing mp3 files. > But I suspect a better answer is: Unless you're familiar with > using SQL databases, you may find that you're better off using an > application already designed for indexing mp3 files, since SQLITE is a > great little database for *building* applicates, but not an application > itself. > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/Saving-tables-tf2714011.html#a7567277 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
