The update zhanghu set money=99999

Reported a 1064 error, but the statement also carried out, I have no language, what's wrong with this

Error message:
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 'update zhanghu set money=99999' at line 1

CodePudding user response:

I think may be because the money is a type of MySQL, so will be such a mistake, you add a single try to money

CodePudding user response:

I put the money into m as fault, not the problem

CodePudding user response:

Which is your mysql version? Money is what kind of? What is the length?

CodePudding user response:

Want me to put money set to varchar, value is quotes will not wrong, of course depends on the actual situation

CodePudding user response:

The zhanghu table structure made by,