Make another column in a table equal to the primary key column In my notes table (MySQL database) I have id as the primary key. I want the column originalid to be the value of the primary key. Here is the query I run after creating a record which I thought would work.

UPDATE notes SET originalid = (SELECT MAX(id) FROM notes) where id = (SELECT MAX(id) FROM notes);


But I get the error


  You can't specify target table 'notes' for update in FROM clause


Any advice or solutions on how I can work around this?
I explained the error message in an earlier post 4.5 years ago (Problem with MySQL subquery)
SUGGESITON : Do it as two queries
SELECT id INTO @maxid FROM notes ORDER BY id DESC LIMIT 1;
UPDATE notes SET originalid = @maxid where id = @maxid;

or
SELECT MAX(id) INTO @maxid FROM notes;
UPDATE notes SET originalid = @maxid where id = @maxid;