sqliteHow do I use SQLite on MacOS?
SQLite is a lightweight and easy-to-use database system that can be used on MacOS. To use it, you need to install the SQLite3 command line interface, which can be done using Homebrew.
brew install sqlite3Once installed, you can access the database from the command line interface. To create a new database, you can use the following command:
sqlite3 my_database.dbThis will create a new database file called my_database.db. To create a new table in the database, you can use the CREATE TABLE command. For example, to create a table called users with two columns name and age, you can use the following command:
CREATE TABLE users (name TEXT, age INTEGER);You can then insert data into the table using the INSERT INTO command. For example, to insert a user called John with an age of 30, you can use the following command:
INSERT INTO users VALUES ('John', 30);You can then query the table using the SELECT command. For example, to get all users with an age of 30, you can use the following command:
SELECT * FROM users WHERE age = 30;This will output all users with an age of 30, for example:
John|30Helpful links
More of Sqlite
- How do I use UUIDs in SQLite?
- How do I use SQLite with Visual Studio?
- How can I use an upsert statement to update data in a SQLite database?
- How do I install and use SQLite on Ubuntu?
- How can I use SQLite with Xamarin Forms?
- How do I use the SQLite sequence feature?
- How can I use SQLite with Xamarin Forms and C#?
- How do I use SQLite VACUUM to reclaim disk space?
- How do I use SQLite REPLACE to update existing records in a database?
- How do I use query parameters with SQLite?
See more codes...