Menu
This query:
UPDATE jos_content SET fulltext='\r\n<br /> \" some other text' WHERE id=3
gives:
ERROR 1064 (42000): 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 'fulltext='\r\n<br /> \" some other text' WHERE id=3' at line 1
Anyone has any idea why?
916
MySQL Error codes Error code 1064: Syntax error Getting a "1064 error" message from MySQL means the query cannot be parsed without syntax errors. In other words it can't make sense of the query.
MySQL no database selected is an error that occurs when you execute a statement without first selecting a database. The database may be completely missing, or you may choose the wrong database if there is more than one database.
fulltext is a reserved word.
http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html
rename your field or put it within backticks '`' (alt + 96)
like so:
UPDATE jos_content SET `fulltext`='\r\n<br /> \" some other text' WHERE id=3
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
