Reply
Contributor
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;

 

Announcements