MySQL 视图,第1349号错误
作者:xling 来源:xling博客 时间:2008-05-18 13:04:00
把下面SQL里的SELECT单独执行,没有问题,但是用来CREATE VIEW 就报错了.
CREATE OR REPLACE VIEW BLOG_V_ADMIN
(ID,NICKNAME,SEX,EMAIL,PHONE,QQ,MSN,HTTP,REGISTER_TIME,
IP,LAST_LOGIN_IP,LOGIN_TIME)
AS
SELECT
A.ID,A.NICKNAME,A.SEX,A.EMAIL,A.PHONE,A.QQ,A.MSN,A.HTTP,A.REGISTER_TIME,
B.IP AS LAST_LOGIN_IP,B.LOGIN_TIME AS LAST_LOGIN_TIME
FROM
BLOG_ADMIN A LEFT JOIN
BLOG_ADMIN_LOGIN_TRACK B ON B.ADMIN = A.ID LEFT JOIN
(SELECT ADMIN,MAX(LOGIN_TIME) AS LOGIN_TIME FROM BLOG_ADMIN_LOGIN_TRACK GROUP BY ADMIN) C ON B.ADMIN = C.ADMIN;
ERROR 1349 (HY000): View's SELECT contains a subquery in the FROM clause
这是BUG吗?见:http://bugs.mysql.com/bug.php?id=16757
木有办法,我只好这样改了:
CREATE OR REPLACE VIEW BLOG_V_ADMIN
(ID,NICKNAME,SEX,EMAIL,PHONE,QQ,MSN,HTTP,REGISTER_TIME,
LOGIN_TIME,LAST_LOGIN_IP)
AS
SELECT
A.ID,A.NICKNAME,A.SEX,A.EMAIL,A.PHONE,A.QQ,A.MSN,A.HTTP,A.REGISTER_TIME,
(SELECT LOGIN_TIME FROM BLOG_ADMIN_LOGIN_TRACK WHERE ADMIN = A.ID ORDER BY LOGIN_TIME DESC LIMIT 1) AS LAST_LOGIN_TIME,
(SELECT INET_NTOA(IP) FROM BLOG_ADMIN_LOGIN_TRACK WHERE ADMIN = A.ID ORDER BY LOGIN_TIME DESC LIMIT 1) AS LAST_LOGIN_IP
FROM
BLOG_ADMIN A;
标签:mysql,错误
0
投稿
猜你喜欢
Python使用Windows API创建窗口示例【基于win32gui模块】
2021-04-14 02:01:10
php替换字符串中间字符为省略号的方法
2023-09-30 20:16:04
Oracle 正则表达式实例详解
2024-01-25 23:43:01
python manage.py runserver流程解析
2022-03-11 13:12:10
ASP如何输出字符
2007-09-22 18:41:00
JSON 和 JavaScript eval使用说明
2024-04-19 10:00:07
python可视化hdf5文件的操作
2022-11-16 16:35:48
Oracle如何设置表空间数据文件大小
2024-01-13 01:00:03
mysql中int(3)和int(10)的数值范围是否相同
2024-01-17 16:37:48
页面自动刷新javascript代码大全
2010-06-28 18:54:00
如何让python的运行速度得到提升
2023-04-26 21:48:35
Python发送手机动态验证码代码实例
2021-10-18 23:42:32
Python切片操作实例分析
2022-05-02 17:49:25
基于JS实现01支付后的10秒倒计时
2024-04-10 11:02:30
python中os库的函数使用
2022-05-03 22:16:57
教你如何使Python爬取酷我在线音乐
2021-02-18 14:13:01
MySQL 选择合适的存储引擎
2024-01-21 08:55:24
Oracle 低权限数据库账户得到 OS 访问权限 提权利用
2009-06-19 17:27:00
Mysql导出数据的正确方法
2024-01-22 11:24:06
详解pycharm配置python解释器的问题
2022-10-14 13:22:08