Re: [sqlite] how do I cd on Mac OX 10?

2011-10-07 Thread TR Shaw

On Oct 7, 2011, at 5:54 PM, TR Shaw wrote:

> 
> On Oct 7, 2011, at 5:46 PM, Mary Andes wrote:
> 
>> Last login: Fri Oct  7 17:26:34 on console
>> Mary-Andess-MacBook-Air:~ mjandes$ sqlite3
>> SQLite version 3.7.5
>> Enter ".help" for instructions
>> Enter SQL statements terminated with a ";"
>> sqlite> cd /Users/mjandes/SQLite3 and Hedis
>>  ...> 
>> I have a Mac Book Air. Lion operating system. I can get onto the terminal 
>> and get onto sqlite3. 
>> But, then I get stuck in trying to tell it to point to a particular 
>> directory. I've tried the above command and it doesn't work. 
>> Can anyone help me? 
> 
> 
> Looks like you have spaces in your path. So either quote the whole path of \ 
> the spaces
> 
>> cd "/Users/mjandes/SQLite3 and Hedis"
>> cd /Users/mjandes/SQLite3\ and\ Hedis
> 
> 
> 
> Standard bash.

My mistake you were trying within sqlite. You need to do the cd in bask (eg 
OSX's terminal shell) And you need to escape the path as I stated.

Tom

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] how do I cd on Mac OX 10?

2011-10-07 Thread Petite Abeille

On Oct 7, 2011, at 11:46 PM, Mary Andes wrote:

> Can anyone help me? 

You cannot 'cd' from inside SQLite shell. 

If you wish to open a specific database, simply point sqlite3 to it before hand:

% sqlite3 /path/to/my/db


http://www.sqlite.org/sqlite.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] how do I cd on Mac OX 10?

2011-10-07 Thread TR Shaw

On Oct 7, 2011, at 5:46 PM, Mary Andes wrote:

> Last login: Fri Oct  7 17:26:34 on console
> Mary-Andess-MacBook-Air:~ mjandes$ sqlite3
> SQLite version 3.7.5
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> cd /Users/mjandes/SQLite3 and Hedis
>   ...> 
> I have a Mac Book Air. Lion operating system. I can get onto the terminal and 
> get onto sqlite3. 
> But, then I get stuck in trying to tell it to point to a particular 
> directory. I've tried the above command and it doesn't work. 
> Can anyone help me? 


Looks like you have spaces in your path. So either quote the whole path of \ 
the spaces

>  cd "/Users/mjandes/SQLite3 and Hedis"
>  cd /Users/mjandes/SQLite3\ and\ Hedis



Standard bash.

Tom
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] how do I cd on Mac OX 10?

2011-10-07 Thread Mary Andes
Last login: Fri Oct  7 17:26:34 on console
Mary-Andess-MacBook-Air:~ mjandes$ sqlite3
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> cd /Users/mjandes/SQLite3 and Hedis
   ...> 
I have a Mac Book Air. Lion operating system. I can get onto the terminal and 
get onto sqlite3. 
But, then I get stuck in trying to tell it to point to a particular directory. 
I've tried the above command and it doesn't work. 
Can anyone help me? 

thanks
Mary
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users