开发者

Locate Database File in SQLITE

I have created a file named "MyFile.db" using SQLite3 from my C#.net application. This file got created in my "D:\MyProject\bin" folder. I have created a table named "MyTable" inside "MyFile.db" from same C# app.

Now I am running sqlite3.exe from my "C:\" drive to get Command Line Shell For SQLite.

How can I get the file "D:\MyProject\bin\MyFile.db" in the SQLite Command Line Shell i.e, how can I locate the file "MyFile.db"开发者_StackOverflow社区 in the command shell to get the data from "MyTable".


You can start sqlite3.exe with the database as a paramater:

sqlite3.exe D:\MyProject\bin\MyFile.db

Or you could open sqlite3 as you are and attach the database at runtime using the syntax described here

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜