Prior to version 3.9.0, SQLite employed a version identifier that contained between two and four numbers. Starting from version 3.9.0, SQLite uses semantic versioning, which presents the major version number, followed by the minor version number, followed by the patch number. Result on my system: 3.28.0 Numbering System If you’re already connected to SQLite, you can find out which version it is with the version_number() function. sqlite3 -version The version_number() Function You can also use the following command if you just want to check the version without actually connecting to SQLite. I get '-bash: mysqladmin: command not found'. When typing anything with MySQL in the terminal like.
However, once connected, you then see the full version number. I have MySQL start/stop in prefpane and I start it with no problem (MySQL is running). Perhaps slightly paradoxically, this obviously requires that you enter the major version number anyway. Use ".open FILENAME" to reopen on a persistent database. Result on my system: SQLite version 3.28.0 14:49:49Ĭonnected to a transient in-memory database. When you first connect to SQLite using a command line interface (such as Terminal on the Mac), the first thing you should see is the version number.
In any case, if you found this page, maybe you need another method to check your SQLite version. Here are a few ways to check your version of SQLite.Īctually, you probably already saw which version you were using when you connected to SQLite.