列“ mary”不存在 [英] Column 'mary' does not exist

问题描述

我在这里做一个简单查询，它返回 Mary列不存在：

i'm doing a simple query here and it returns that column 'Mary' does not exist:

SELECT  telephone.telephonenumber as tel
FROM    person, telephone
WHERE   person.idperson = telephone.idperson
AND person.personname = ‘Mary’;

有人可以解释会发生什么吗？我不希望玛丽作为专栏，但希望作为一个值。

Can someone explain what can be happening? I don't want Mary as a column, but as a value.

在此先感谢
Gabriel

Thanks in advance, Gabriel

推荐答案

使用普通单引号分隔字符串常量'Mary'而不是智能引号'Mary '

Use plain single quotes to delimit a string literal 'Mary' not smart quotes ‘Mary’

这篇关于列“ mary”不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！