UPDATE单元格为空MYSQL PHP [英] UPDATE cell to be empty MYSQL PHP

问题描述

环顾Google和Stack Overflow，也许我只是盲目. 有没有一种方法可以用"(空)值更新表单元格. 像这样说:

Looked around on Google and Stack Overflow, maybe I'm just blind though. Is there a way to UPDATE a table cell with an " " (empty) value. Let's say like:

mysql_query("UPDATE table SET cellname = ' ' WHERE id = '$idneeded'");

任何帮助，不胜感激.

Any help much appreciated.

推荐答案

您应该知道空字符串''与空格字符串' '不同，并且与NULL值也不相同.

you should know that empty string '' is not same as space string ' ' and not same as NULL value.

将单元格值更新为空字符串:

to update the cell value to empty string :

mysql_query("UPDATE table SET cellname = '' WHERE id = '$idneeded'");

这篇关于UPDATE单元格为空MYSQL PHP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！