$ cd yourapp/db $ sqlite3 develoment.sqlite3
$ .help $ .databases $ .use databasename $ .tables On Wed, Nov 7, 2012 at 7:05 PM, saikiran mothe <[email protected]>wrote: > Hi Fabian, > > Go to yourapp/db > > then you will see development.sqlite3 and test.sqlite3 > > Run > -- sqlite3 development.sqlite3 > > -- .databases > > -- .help > > ---.tables > > check .help command you will know more commands on sqlite3 > > Thanks, > Saikiran Mothe > > > > > On Wed, Nov 7, 2012 at 7:00 PM, Fabian Becker > <[email protected]>wrote: > >> >>> One more question how to switch database in Sqlite3. >>> In mysql we fire >>> use database_name >>> In postgre we fire >>> \c database_name >>> But what to fire in sqlite3 ? >>> I do lots of google but i get nothing. >>> >>>> >>>> >> You only have a single database in SQLite3, there is no need to select >> one. >> >> Type ".help" inside the SQLite3 shell to learn more. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.

