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|
- Android Error Unexpected cast to Button: layout tag was FrameLayout
- ADT quit unexpectedly error on Mac OSX Android Eclipse SDK
- Parsing Data for android-21 failed unsupported major.minor version 51.0
- Android Studio Ctrl Shift o auto import not working
- java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant) with this activity.
- Android : How to make TextView Scrollable
- This class should be public (android.support.v7.internal.widget.ActionBarView.HomeView) Lint Error
- Integrating Android Facebook SDK 3.17.2 Tutorial
- Android R Cannot Be Resolved To A Variable
- Android : Exception raised during rendering: action_bar API 22
- How to take screenshot on Android
- Read Text file from SD Card : Android Programming
- How to make Android EditText not editable
- Your Android SDK is out of date or is missing templates. Please ensure you are using SDK version 22 or later.
- The declared package does not match the expected package Eclipse
- Can't Run SDK Manager find_java.bat issue
- What is Android Toast.LENGTH_SHORT and Toast. LENGTH_LONG durations
- Android Emulator Soft Back button action using Computer keyboard
- Multiline EditText in Android Example
- Use 5G Network on Android Emulator
- Make Android TextView Clickable like Buttons
- How to empty trash in Android Device
- Android : Execute some code after back button is pressed
- Disable Fading Edges Scroll Effect Android Views
- How To Disable Landscape Mode in Android Application
- How to query database table names [MySQL/Oracle/SQL Server] - MySQL
- Upload Pdf file using PHP Script - PHP
- Identify MySQL version in MySQL Command Line Prompt - MySQL
- Java: Create Temporary Directory and File and Delete when application terminates - Java
- JavaScript : Get url protocol HTTP, HTTPS, FILE or FTP - JavaScript
- Writing your first Hello, World! 🌍 JavaScript code Tutorial - JavaScript
- Fix Microsoft Teams Admin Center error - The Security zone setting isn't configured correctly - Teams
- [Fix] Powershell - Term winget is not recognized as the name of a cmdlet function or script file - Powershell