mysql创建视图问题

qq_412bd180

积分: 3010

这家伙很懒，什么个性签名都没有留下。

CREATE VIEW v_employee AS (
SELECT * , taskcount = (SELECT COUNT(id) FROM t_task AS t WHERE t.eid = e.id) FROM t_employee AS e;
)

在mysql里创建视图失败， sql语句应该怎么改

在nutz文档使用视图一节中的例子

wendal

多了分号

CREATE VIEW v_employee AS (
SELECT * , taskcount = (SELECT COUNT(id) FROM test_task AS t WHERE t.eid = e.id) FROM test_employee AS e
)

[SQL]CREATE VIEW v_employee AS (
SELECT * , taskcount = (SELECT COUNT(id) FROM test_task AS t WHERE t.eid = e.id) FROM test_employee AS e
)

[Err] 1054 - Unknown column 'taskcount' in 'field list'

wendal

那是pgsql的写法，你用自己的建表语句就好啦，何必纠结这个例子

请先登陆