Search code examples
mysqlmysql-error-1064

Why am I getting #1064 - You have an error in your SQL syntax


The original query was:

UPDATE `test`.`documents` SET `title` = ‘测试中文’, `content` = ‘this is my test document number two,应该搜的到吧’ WHERE `documents`.`id` = 2;

Which resulted in:

#1064 - 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 'my test document number two,应该æ

I changed the wrong '

UPDATE 'test'.'documents' SET 'title' = '测试中文', 'content' = 'this is my test document number two,应该搜的到吧' WHERE 'documents'.'id' = 2;

and got:

#1064 - 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 ''test'.'documents' SET 'title' = '测试中文', 'content' = 'this is my test do' at line 1

How do I set my my.ini?

I used XAMPP Lite, and MySQL version 5.1.37.


Solution

  • UPDATE test.documents
    SET title = '测试中文',
    content = 'this is my test document number two,应该搜的到吧'
    WHERE documents.id = 2; 
    

    is also ok,and the same question is also my 3