更新不起作用 [英] Update Doesn't Work

问题描述

我的UPDATE脚本无法正常工作。我只是找不到什么是错的，每个变量都被声明了。请查看我的代码有什么问题。谢谢。


***这是来自编辑的地方的代码***

My UPDATE script just doesn''t work. I just couldn''t find what was wrong, every variable is declared. Please find what''s wrong with my code. Thanks.

***THIS IS THE CODE FROM WHERE THE EDITING WILL TAKE PLACE***

展开 | 选择 | Wrap | 行号

推荐答案

如果您正在尝试限定表/字段/模式名称，我认为您必须使用而不是。

If you''re trying to qualify a table/field/schema name, I think you have to use ` and not ''.

我尝试根据你的建议修改我的PROCESSING页面的代码，但仍然出现了同样的问题。请检查我的代码。另外，我附上了一个显示错误的图片。

I tried revising the code of my PROCESSING page as per your suggestion, and still the same problem occurred. Please kindly check my code. Also, I''ve attached an image showing the error.

展开 | 选择 | Wrap | 行号

我不能真的看看错误说的是什么，它太小了。您是否尝试过输出SQL并通过DBMS手动运行它，我假设它是MySQL？

I can''t really see what the error says, it''s too small. Have you tried outputting the SQL and running it manually through the DBMS, which I''m assuming is MySQL?

这篇关于更新不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！