Hi guys!
I’m having trouble doing an insert through the SQL API to my mysql database
These two queries return a syntax error that I am not able to resolve.
Here are the two queries I tried:
INSERT INTO usuario_pediatra
(nome
,cpf
,crm
,email
,telefone
,senha
,clinica_nome
,clinica_cnpj
,clinica_end
,clinica_email
,clinica_tel
) VALUES (?,?,?,?,?,?,?,?,?,?,?)
SQL Database Connector issue: 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 ‘?)’ at line 1
INSERT INTO usuario_pediatra
(nome
,cpf
,crm
,email
,telefone
,senha
,clinica_nome
,clinica_cnpj
,clinica_end
,clinica_email
,clinica_tel
) VALUES (‘?’,‘?’,‘?’,‘?’,‘?’,‘?’,‘?’,‘?’,‘?’,‘?’,‘?’)
SQL Database Connector issue: 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 ‘nome’‘,’‘4444’‘,’‘aaaac’‘,’‘aaaad’‘,’‘2121’‘,’‘aaaae’‘,’‘212’‘,’‘aaaaf’‘,’‘aaaag’ at line 1
I’m using heroku database.