显示引用mysql中其他列的列内容

guykilcj  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(295)

我有一个名为ants的表,其中包含:

现在我想看看专栏的内容 phone_info 它的id为,例如onext1。我试过使用:

SELECT phone_info WHERE id="onexT1" FROM ants;

但它返回一个错误:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id="onexT1" FROM  ants' at line 1

我该怎么做?谢谢:)

bfrts1fy

bfrts1fy1#

使用单引号:

SELECT phone_info WHERE id = 'onexT1' FROM ants;

相关问题