$ 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.


Reply via email to