0
Good afternoon, I’m having similar problems when I’m trying to research the comic. Digito:
SELECT * FROM profission(cod_prof,nome_prof,sexo_prof,cref_prof,titulo_prof)
VALUES ('Fernando','masculino','0001','doutorado');
and I have the result:
ERROR: syntax error at or near "'Fernando'" LINE 1: ...ome_prof,sexo_prof,cref_prof,titulo_prof) values ('Policapo'... ^ SQL state: 42601 Character: 186
Someone might indicate what the problem would be. Grace.
According to the documentation this is not a syntactically valid construction for the SELECT command. I don’t understand what you want to do. If the data is in the database and you want to recover it has no sense the VALUES clause. Maybe the WHERE clause meets your needs.
– anonimo
I get it. Actually what’s happening is that I’m trying to do the database search. Thank you
– Fernando
See if this is it: SELECT * FROM profission WHERE nome_prof='Fernando' AND sexo_prof='masculine' AND cref_prof='0001' AND titulo_prof='doctorate';
– anonimo