mysql视图改造实体表_MySQL视图表创建与修改

1、创建 CREATE [OR REPLACE] [lt;algorithm attributesgt;] VIEW [database.]lt; namegt; [(lt;columnsgt;)]AS lt;selec

1、创建

CREATE [OR REPLACE] [] VIEW [database.]< name> [()]

AS []

例子：

CREATE VIEW `view_articles`

AS

SELECT

a.id AS id,

a.title AS title,

a.content AS content,

t.name AS tagname,

u.firstname AS "username"

FROM `articles` a

LEFT JOIN `tags` t

ON a.tag_id = t.id

LEFT JOIN `users` u

ON a.user_id = u.id

ORDER BY a.posttime DESC;

修改

ALTER [] VIEW [.]< name> [()]

AS[]

例子：

ALTER VIEW `view_articles`

AS

SELECT

a.id AS id,

a.title AS title,

a.content AS content,

a.posttime AS posttime,

t.name AS tagname,