《Mysql實例MySQL 視圖 第1349號錯誤解決方法》要點：
本文介紹了Mysql實例MySQL 視圖 第1349號錯誤解決方法，希望對您有用。如果有疑問，可以聯系我們。
代碼如下:
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;?
轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/6361.html
