This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Error in syntax

Hello, I have this query meant to add a value into my table but it returns error 1054. If I try to remove the `, it returns the same, and if I try to put it in ' it returns 1064. I cannot figure that is wrong. Could you please help me?

INSERT INTO `blocker` ( id, type, capacity, loaqd, created, updated ) VALUES (1,'GoBGP-FlowSpec', 100, 0,'2017-04-13 13:44:34','2017-04-13 13:44:34');

Answer Answered by Ian Gilfillan in this comment.

There is no error in this syntax, you need to give more information - table structure, how are you running it?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.