执行SQL DELETE查询时出错[重复]

This question already has an answer here:

这个问题在这里已有答案:

• MySQL error: Unknown column in 'where clause' 5 answers

MySQL错误:'where子句'5答案中的未知列

I am trying to develop a database for "Diseases Detection Management System " on phpmyAdmin using MAMP server. I am also trying to apply SQL queries on this database like SELECT, INSERT, UPDATE, DELETE etc.But during executing DELETE query I got an error.

我正在尝试使用MAMP服务器在phpmyAdmin上开发“疾病检测管理系统”数据库。我也试图在这个数据库上应用SQL查询,如SELECT,INSERT,UPDATE,DELETE等。但是在执行DELETE查询期间我收到了一个错误。

Delete Statement:

DELETE FROM `disease_information` WHERE `Disease_name`=`Fever`

But when i simulate the above query it display the following error message:

但是当我模拟上面的查询时,它会显示以下错误消息:

Error Message:

 #1054 - Unknown column 'Fever' in 'where clause'

I had searched about this error on many websites and on stack overflow also but don't get the relevent answer.Here is the link from where i had searched.

我曾在许多网站和堆栈溢出中搜索过这个错误,但是没有得到相关答案。这里是我搜索过的链接。

Link: Link of * from where i had searched about that

链接:*的链接从我搜索过的地方

Kindly help me to remove the above error so that i will move forward.

请帮我删除上述错误,以便我继续前进。

2 个解决方案

#1

Use normal quote marks rather than backticks around Fever. Might help

使用正常的引号而不是发烧周围的反引号。可能有帮助

#2

DELETE FROM `disease_information` WHERE `Disease_name`='Fever'