I am new to SQLITE. I am trying to open a database through Sqlite3.exe shell. My database file path has hyphen in it.. on entering .open C:\Users\Admin\OneDrive - batch\db.sqlite3

i am getting below error

unknown option: -

can anyone help..

I tried double quote around path but in that case I am getting

Error: unable to open database

Thanks in advance..

CodePudding user response：

Have you tried providing path like that:

C:\Users\Admin\"OneDrive - batch"\db.sqlite3

CodePudding user response：

changing

1. backward slashes to forward

2. adding double quotes worked...

below is the solution

.open "C:/Users/Admin/OneDrive - batch/db.sqlite3"