Posts by Luan Araujo • 1 point
3 posts
-
0
votes1
answer217
viewsA: MYSQL - SUM within IF
is.. I had tried subquery before and it didn’t go very well.. Trying here again got like this: select *, (SELECT COALESCE(sum(condicional_itens_status.quantidade) ,0) as devolvido FROM…
-
0
votes1
answer217
viewsQ: MYSQL - SUM within IF
Good morning guys! All right? I took a look and found nothing about it... If it’s repeated topic, I’m sorry.. Situation: I need to filter the "conditionals" by status, but these status I define from…
-
0
votes1
answer707
viewsQ: if () syntax in a Trigger
I’m having difficulties with the if() syntax in phpmyadmin. I have to create a TRIGGER to insert information in a log when the name of an animal table animals is changed. But there is a syntax error…