我有一个在本地主机中正常运行的sql查询,但是当我将其上传到安装了更高版本的MySQL的真实服务器时,它给了我错误:
" #1054 - Unknown column 'subject.customers_fullname' in 'field list' "
这是查询...
SELECT nf.*,
actor.customers_fullname AS actor_name,
actor.customers_id AS actor_id,
subject.customers_fullname AS subject_name
FROM portal_notifications nf,
customers actor,
customers SUBJECT
WHERE subject_id = 1
AND nf.actor_id = actor.customers_id
AND nf.subject_id = SUBJECT.customers_id
AND status = 'unseen'
ORDER BY nf.id DESC LIMIT 0,10
尝试在
字段列表中写下它,因为 alisas 名称是 SUBJECT
并且您使用的是subject
在 UNIX
中区分大小写。
SUBJECT.customers_fullname AS subject_name
而不是
subject.customers_fullname AS subject_name
默认情况下,表别名在 Unix 上区分大小写,但在 Windows 或 Mac OSX 上则不区分大小写。
别名在操作系统参考中区分大小写UNIX
。