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 <varunkaja.1...@gmail.com> 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