我有一个名为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
我该怎么做?谢谢:)
1条答案
按热度按时间bfrts1fy1#
使用单引号: