SQLI Query not Updating NULL

Question

我在SQLI中更新NULL值时遇到了问题。

SELECT * FROM sqli_information;
UPDATE sqli_information
SET optional_security_question = "Not Available"
WHERE optional_security_question = NULL;

没有错误，但它只是保持为null。我试图获得optional_security_question中的每个NULL值，并将其转换为Not Available。

Answer 1

尝试使用以下语法:

UPDATE sqli_information
SET optional_security_question = "Not Available"
WHERE optional_security_question IS NULL;

Answer 2

尝试更改"WHERE optional_security_question = NULL;"WHERE optional_security_questionIS零;"然后看看它是否允许你更新