MySQL语法错误 - 不确定问题[重复]

Question

This question already has an answer here:

• Syntax error due to using a reserved word as a table or column name in MySQL 1 answer

I am trying to use the following syntax to update my database, but it is not working, and when I use Instant SQL Formatter, it says:

Syntax Error: =(1,76) expected token:(

Here is the MySQL code: (that is being run by PHP)

UPDATE parts SET name='How do you use it?', part_order='0', top='334', left='44', width='150', height='26', value='', script='on mouseup
answer \"To use jsCard, all you need is an account! From there you can create stacks, then cards, then you can start building on those cards. To build on cards, simply double click on an object in the tools palette, assign a name to your new object, then, if it is a button, add a script to make it do wonderful things!\"
end mouseup', visible='1', enabled='1', style='5', family='0', locktext='0', hilite='0', autohililte='1' WHERE stacks_id=1 AND cards_id=1 AND part_id=19

Can anyone tell me what is wrong with my syntax?

</div>

Answer 1

That's probably because your INSERT statement contain the below line where left is string function and so it's expecting () around it

left='44'

You should escape it using backtique like

UPDATE parts SET 
name='How do you use it?', 
part_order='0', 
top='334', 
`left`='44', <-- Here
width='150', 
height='26', 
value='', 
script='on mouseup
answer \"To use jsCard, all you need ...', 
visible='1', 
enabled='1', 
style='5', 
family='0', 
locktext='0', 
hilite='0', 
autohililte='1' 
WHERE stacks_id=1 
AND cards_id=1 
AND part_id=19