Skip to content

Instantly share code, notes, and snippets.

@unknowntpo
Created September 2, 2022 03:29
Show Gist options
  • Save unknowntpo/0f7784df5d7d409f7f2ee9bf4b1f8c00 to your computer and use it in GitHub Desktop.
Save unknowntpo/0f7784df5d7d409f7f2ee9bf4b1f8c00 to your computer and use it in GitHub Desktop.
db_version_control.version_2_of_data
id c0 c1 username version is_deleted
1 old0 old1 Eric 1 f
2 old2 old2 Eric 1 f
-- select active data with version == 2
select * from data where version = 2 and is_deleted = false;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment