Posts by user3111254 • 1 point
4 posts
-
0
votes1
answer73
viewsA: Update via another table - Mysql
So guys, I managed to solve here through this update update rev_tasks t inner join (select task_id, count(1) as qtd from rev_reviews where revisado = 'Nao' group by task_id) r on t.id = r.task_id…
-
0
votes1
answer73
viewsQ: Update via another table - Mysql
I have the following problem: I have a table rev_tasks which contains id as key, and a second table rev_reviews and has as a foreign key task_id, pointing to the task, in addition I have a field…
-
0
votes2
answers392
viewsA: Error in Trigger - Mysql
Hey, guys, I got this thing down here, was missing the DELIMITER $$, with DELIMITER you can place the ';' required. also DECLARE does not have@and selects when done to store in a variable, you…
-
0
votes2
answers392
viewsQ: Error in Trigger - Mysql
I created the following Rigger, but it has a syntax error that I can’t find. The error is as follows ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that Corresponds to…