I typed exactly what you typed there and i get SQL error: no such table: bar my command window doesnt have : "sqlite3 foo.sqlite" like yours
P Kishor-2 wrote: > >>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] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/Saving-tables-tf2714011.html#a7567649 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
