Skip to content

Instantly share code, notes, and snippets.

@afcotroneo

afcotroneo/omni-unique-id

Created January 27, 2022 14:02
Show Gist options
  • Save afcotroneo/f1a17d50f94c6cceb4dec7c4f30e2d3d to your computer and use it in GitHub Desktop.
Save afcotroneo/f1a17d50f94c6cceb4dec7c4f30e2d3d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
omni-unique-id
## add a unique id to your table
alter table table_name add column unique_id_int BIGINT;
update table_name
set unique_id_int = rowid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment