UPDATE movie2000 SET score = 9.0;
UPDATE movie2000 SET score = 9.0 WHERE title='Almost Famous';
UPDATE movie2000 SET score = (SELECT MAX(score) FROM movie2000) WHERE title = 'Almost Famous' ;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SELECT * FROM movie2000 WHERE title = 'Almost Famous' FOR UPDATE OF score NOWAIT;
LOCK TABLE movie2000 IN EXCLUSIVE MODE;
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
DELETE FROM movie2000 WHERE title LIKE 'R%'; INSERT INTO movie2000(id, title, yr) VALUES(1702,'Roman Holiday,2000', 2000);