MySQL Forums
Forum List  »  Italian

Re: UPDATE e SELECT SUM
Posted by: Mauro Rinaldi
Date: April 05, 2015 03:42PM

Risolto il problema!

ecco la sintassi giusta per ciò che volevo fare:

UPDATE brani SET punteggio =(SELECT SUM(valore) FROM `voti`WHERE brani.idBrano =`idBrano`)

evidentemente scrivere sul forum è terapeutico...

Options: ReplyQuote


Subject
Views
Written By
Posted
2147
April 05, 2015 03:03PM
Re: UPDATE e SELECT SUM
947
April 05, 2015 03:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.