view可能会起作用,具体取决于现有系统施加的限制以及imposed by views。它可以节省重复数据:
CREATE TABLE web_users (username VARCHAR(255), password VARCHAR(255));
CREATE VIEW forum_users AS SELECT username, password FROM web_users;
INSERT INTO web_users VALUES ('user1', 'password1');
SELECT * FROM forum_users;
+----------+-----------+
| username | password |
+----------+-----------+
| user1 | password1 |
+----------+-----------+
INSERT INTO forum_users VALUES ('user2', 'password2');
SELECT * FROM forum_users;
+----------+-----------+
| username | password |
+----------+-----------+
| user1 | password1 |
| user2 | password2 |
+----------+-----------+
SELECT * FROM web_users;
+----------+-----------+
| username | password |
+----------+-----------+
| user1 | password1 |
| user2 | password2 |
+----------+-----------+