Cacher is the code snippet organizer for pro developers

-- create
CREATE VIEW view_student(Sno, Sname, Ssex, Sage, Sdept)
	AS
	SELECT Sno MOD 100000, Sname, Ssex, Sage, Sdept FROM Student;

-- update
UPDATE view_student
SET Sno = Sno MOD 100000;

-- drop
DROP VIEW view_student;