Posts: 52
Registered: ‎02-15-2016

update beeswax_savedquery table in hue database

Hi , I have a situation . is it ok if i update beeswax_savedquery table in hue database.


a user now have a new id ,so he wants all the saved queries in old id to moved to new id .


can i follow this approach .


CREATE TEMPORARY TABLE tmptable SELECT * FROM table WHERE primarykey = 1;
UPDATE tmptable SET primarykey = 2 WHERE primarykey = 1;
INSERT INTO table SELECT * FROM tmptable WHERE primarykey = 2;