MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Trouble Updating Table with Multiple Rows with Different Values
Posted by: Peter Brawley
Date: October 21, 2015 11:12AM

1. SELECT statements like that aren't allowed in Triggers, you need ...

set sbvalue = (select ... from ... where...);

2. Missing FROM cluase in your SELECTs.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Trouble Updating Table with Multiple Rows with Different Values
Becca Duran
October 15, 2015 08:41AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 15, 2015 12:56PM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 19, 2015 09:08AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 19, 2015 11:07AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 20, 2015 08:59AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 20, 2015 01:51PM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 21, 2015 07:53AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 21, 2015 11:12AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 28, 2015 07:18AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 29, 2015 11:40AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
November 09, 2015 11:11AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
November 09, 2015 11:26AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
October 21, 2015 09:22AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Peter Brawley
October 31, 2015 12:16AM
Re: Trouble Updating Table with Multiple Rows with Different Values
Becca D
November 09, 2015 11:13AM


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.