Skip to content

Instantly share code, notes, and snippets.

@NattyNarwhal
Created March 8, 2018 17:18
Show Gist options
  • Save NattyNarwhal/ff0c6268f0004d49da48c770738ebf29 to your computer and use it in GitHub Desktop.
Save NattyNarwhal/ff0c6268f0004d49da48c770738ebf29 to your computer and use it in GitHub Desktop.
-- drop table MirrorContentsTempCopy; --uncomment if exists somehow
create temporary table MirrorContentsTempCopy engine=memory select * from MirrorContents where MirrorUUID = 0x00000000000000000000000000000000;
update MirrorContentsTempCopy set MirrorUUID = 0x00000000000000000000000000000038;
insert into MirrorContents select * from MirrorContentsTempCopy;
drop table MirrorContentsTempCopy;
select * from MirrorContents where MirrorUUID = 0x00000000000000000000000000000038;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment