Here are a few ways to check your version of SQLite.
Actually, you probably already saw which version you were using when you connected to SQLite.
In any case, if you found this page, maybe you need another method to check your SQLite version.
Connecting to SQLite
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.
MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts. MySQL Cluster Community Edition is available as a separate download. The reason for this change is so that MySQL Cluster can provide more frequent updates. Here are a few ways to check your version of SQLite. Actually, you probably already saw which version you were using when you connected to SQLite. In any case, if you found this page, maybe you need another method to check your SQLite version. MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of directories. You can also use the mysqladmin program to create databases. See Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”.
Result on my system:
Perhaps slightly paradoxically, this obviously requires that you enter the major version number anyway. However, once connected, you then see the full version number.
Without Connecting
You can also use the following command if you just want to check the version without actually connecting to SQLite.
The version_number() Function
If you’re already connected to SQLite, you can find out which version it is with the version_number() function.
Result on my system:
Numbering System
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.
Check Mysql Version In Mac Shortcut
Prior to version 3.9.0, SQLite employed a version identifier that contained between two and four numbers.
Check Mysql In Mac
See Version Numbers in SQLite on the SQLite website for more information about this.
Also, here’s a History of SQLite Releases in case you’re interested.