If you are new to SQLite or have just downloaded the latest SQLite3 version of Command-prompt or Terminal based utility that you may have found that the Dot-command .open, when executed to open an existing SQLite database file, gives the following error,
Command : $ sqlite3 .open /Users/code2care/myDatabase.db
Error: unknown command or invalid arguments: "open". Enter ".help" for help
To troubleshoot let's look into the .help file,
Code2care-Mac-mini::~ code2care$ sqlite3 /Users/code2care/myDatabase2.db
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
.backup ?DB? FILE Backup DB (default "main") to FILE
.bail ON|OFF Stop after hitting an error. Default OFF
.databases List names and files of attached databases
.dump ?TABLE? ... Dump the database in an SQL text format
If TABLE specified, only dump tables matching
LIKE pattern TABLE.
.echo ON|OFF Turn command echo on or off
.exit Exit this program
.explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off.
With no args, it turns EXPLAIN on.
.header(s) ON|OFF Turn display of headers on or off
.help Show this message
.import FILE TABLE Import data from FILE into TABLE
.indices ?TABLE? Show names of all indices
If TABLE specified, only show indices for tables
matching LIKE pattern TABLE.
.log FILE|off Turn logging on or off. FILE can be stderr/stdout
.mode MODE ?TABLE? Set output mode where MODE is one of:
csv Comma-separated values
column Left-aligned columns. (See .width)
html HTML <table> code
insert SQL insert statements for TABLE
line One value per line
list Values delimited by .separator string
tabs Tab-separated values
tcl TCL list elements
...
...
...
|ADsADsAds|
You would see that there is a .open command that exists in Help. It seems that it has been removed/deprecated.
Workaround/Solution
?? Simply open the Database file without the .open keyword.
Code2care-Mac-mini:~ code2care$ sqlite3 /Users/code2care/myDatabase.db
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
|ADsADsAdss|
More Posts related to Android,
- Increase Android Emulator Timeout time
- Android : Remove ListView Separator/divider programmatically or using xml property
- Error : Invalid key hash.The key hash does not match any stored key hashes
- How to Change Android Toast Position?
- Android Alert Dialog with Checkboxes example
- Android : No Launcher activity found! Error
- Android Development: Spinners with Example
- Failed to sync Gradle project Error:failed to find target android-23
- INSTALL_FAILED_INSUFFICIENT_STORAGE Android Error
- Disable Fading Edges Scroll Effect Android Views
- How to create Toast messages in Android?
- Channel 50 SMSes received every few minutes Android Phones
- Android xml error Attribute is missing the Android namespace prefix [Solution]
- Create Custom Android AlertDialog
- How To Disable Landscape Mode in Android Application
- Android Development - How to switch between two Activities
- incorrect line ending: found carriage return (\r) without corresponding newline (\n)
- Generate Facebook Android SDK keyhash using java code
- Android Error Generating Final Archive - Debug Certificate Expired
- 21 Useful Android Emulator Short-cut Keyboard Keys
- Android RatingBar Example
- 11 Weeks of Android Online Sessions-15-Jun-to-28-Aug-2020
- Download interrupted: Unknown Host dl-ssl.google.com Error Android SDK Manager
- fill_parent vs match_parent vs wrap_content
- Android : Connection with adb was interrupted 0 attempts have been made to reconnect
More Posts:
- Set Custom Background Wallpaper on Mac Terminal (macOS Ventura) - MacOS
- Python 3.x - SQLite 3 Database CRUD Operations Examples - Python
- How to Freeze Top Row in Excel for Mac - Windows
- How to hide lines in Notepad++ - NotepadPlusPlus
- How to Run all Cells at Once Jupyter Notebook - Python
- How to hide or disable iOS 14 App Library on iPhone? - Apple
- Default speed of Marquee tag : SCROLLAMOUNT - Html
- [Solution] Java Error Code 1603. Java Update did not complete. - Java