Re: [sqlite] Regarding file extension for sqlite command prompt

[R.A. Nagy]

Use .read to load & execute .sql files.

The .open is for databases, not external / textual command files.

Here are some introductory videos:

https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy



On Fri, Jun 24, 2016 at 6:07 AM, Kaja Varunkumar 
wrote:

> Hello,
>
>  I am new to SQLite, I have seen the  commands for command prompt of
> SQLite. I have some query files with format .sql. Whenever I try to open
> the files using command .open and read the files . I am getting an error of
> file encrypted and not in the database.   My question's, are there any
> format to open files in SQLite? After creating the tables in one session
> that are not shown in another session.  How to avoid this case ?
>
>
> Thanks,
>  K Varun Kumar
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Regarding file extension for sqlite command prompt

[Kaja Varunkumar]

Hello,

 I am new to SQLite, I have seen the  commands for command prompt of
SQLite. I have some query files with format .sql. Whenever I try to open
the files using command .open and read the files . I am getting an error of
file encrypted and not in the database.   My question's, are there any
format to open files in SQLite? After creating the tables in one session
that are not shown in another session.  How to avoid this case ?


Thanks,
 K Varun Kumar
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users