Sql insert fails

Asked May 03 '23 at 15:12

Active May 03 '23 at 15:12

Viewed 23 times

Hello I am trying to save an entity in Symfony, but I am receiving an error:

INSERT INTO postfach (protocol, url, port, benutzername, passwort, ssl, tls) VALUES (1, 1, 1, 1, 1, 1, 1);

SQL Fehler (1064): 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 'ssl, tls) VALUES (1, 1, 1, 1, 1, 1, 1)' at line 1

I think the problem might be the word ssl, because when I remove it it works fine. Is this some kind of reserved word?

asked May 03 '23 at 15:12

eT4aa

Are ssl and tls columns of the postfach table? – fvu May 03 '23 at 15:15
[apparently ssl is a reserved keyword](https://mariadb.com/kb/en/reserved-words/) – fvu May 03 '23 at 15:19
Yes ssl is a column – eT4aa May 03 '23 at 15:27
I think this Silvester my question thank you – eT4aa May 03 '23 at 15:27

Sql insert fails

0 Answers0