Why can’t I update a record in MariaDB?

Show activity on this post. Closed 4 years ago. Error updating record: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘condition=’-78′ WHERE id=’2” at line 1

How to resolve the MySQL error “you have an error in syntax?

How to resolve the MySQL error “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?” To avoid this type of error in MySQL stored procedure, you need to change the delimiter ; to //.

What is error 1064 in SQL Server?

The 1064 error displays any time you have an issue with your SQL syntax, and is often due to using reserved words, missing datain the database, or mistyped/obsolete commands. So follow along and learn more about what the 1064 error is, some likely causes, and general troubleshooting steps.

How to avoid error in MySQL stored procedure?

To avoid this type of error in MySQL stored procedure, you need to change the delimiter ; to //. Suppose if you are using stored procedure or triggers or even function then you need to change the delimiter. The syntax is as follows. DELIMITER // CREATE PROCEDURE yourProcedureName () BEGIN Statement1, . .