Skip to content

Instantly share code, notes, and snippets.

@unknowntpo
Created September 2, 2022 00:43
Show Gist options
  • Save unknowntpo/63cd414826f71e31688eff5f57ed017b to your computer and use it in GitHub Desktop.
Save unknowntpo/63cd414826f71e31688eff5f57ed017b to your computer and use it in GitHub Desktop.
db_version_control.insert_new_data_to_temp_table
CREATE TABLE temp (LIKE data INCLUDING ALL);
insert into temp (c0, c1, username, version, is_deleted) values
('modified', 'old1', 'Eric', 2, false),
('old2', 'old2', 'Eric', 2, false),
('new0', 'new1', 'Kevin', 2, false);
select * from temp;
id c0 c1 username version is_deleted
3 modified old1 Eric 2 f
4 old2 old2 Eric 2 f
5 new0 new1 Kevin 2 f
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment