sqlite3 foo.sqlite
SQLite version 3.3.7 Enter ".help" for instructions sqlite> CREATE TABLE bar (a, b); sqlite> INSERT INTO bar (a, b) VALUES (1, 'my mp3'); sqlite> .quit
.. time passes..
sqlite3 foo.sqlite
SQLite version 3.3.7 Enter ".help" for instructions sqlite> SELECT * FROM bar; 1|my mp3 sqlite> On 11/27/06, sebcity <[EMAIL PROTECTED]> 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] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/Saving-tables-tf2714011.html#a7567183 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ ------------------------------------------------------------------------------------------------------- collaborate, communicate, compete ==================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------