如何在MySQL中创建视图?
答
http://dev.mysql.com/doc/refman/5.5/en/create-view.html
例子:
Create View `MyViewName` as
Select
col1, col2, col3
From
myTable T
答
CREATE VIEW v AS SELECT * FROM t;
你有与手动什么问题? http://dev.mysql.com/doc/refman/5.0/en/create-view.html – 2011-03-03 20:08:50
@@ nick rulez:我总是信任不同类型的建议和答案的*。这是我张贴在这里。 – Fero 2011-03-05 06:48:14
感谢您的夸奖。但是,我们宁愿你试着先弄明白。 – mellamokb 2011-03-05 13:01:11