05-09-2017 09:11 AM
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;