sqliteHow do I use UUIDs in SQLite?
UUIDs (Universally Unique Identifiers) can be used in SQLite to create a unique identifier for each row in a table. To use UUIDs in SQLite, you first need to create a table with a column to store the UUIDs. The following example creates a table named users
with a column named uid
to store the UUIDs:
CREATE TABLE users (
uid UUID PRIMARY KEY,
name TEXT
);
Then you can insert UUIDs into the table using the uuid()
function. The following example inserts a row with a new UUID into the users
table:
INSERT INTO users (uid, name) VALUES (uuid(), 'John Doe');
The uuid()
function generates a version 4 UUID, which is composed of random numbers and letters.
Code explanation
CREATE TABLE
- creates a table with the specified columns and data typesUUID
- the data type used to store the UUIDsPRIMARY KEY
- ensures that each row has a unique identifierINSERT INTO
- inserts a row into the specified tableuuid()
- generates a new version 4 UUID
Helpful links
More of Sqlite
- How do I use SQLite with Zephyr?
- How can SQLite and ZFS be used together for software development?
- How do I use the SQLite ZIP VFS to compress a database?
- How do I extract the year from a datetime value in SQLite?
- How do I use the SQLite VARCHAR data type?
- How do I use SQLite KMM to create a database?
- How do I call sqlitepcl.raw.setprovider() when using SQLite?
- How do I use SQLite to retrieve data from a specific year?
- How can I use SQLite with Xamarin?
See more codes...