MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: IF ELSE
Posted by: Barry Galbraith
Date: March 26, 2023 06:24PM

Quote

IF @cnt = 0 THEN SELECT @mnewnumber := Nextra5 from Storage01 ;
I'm going to assume that Nextra5 is a column in table Storage01, and that there is 1 row in Storage01.

Does this work? 
IF @cnt = 0 THEN SELECT Nextra5 into @mnewnumber from Storage01 ;

Good luck,
Barry.

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


Subject
Written By
Posted
IF ELSE
Michael Smith
March 15, 2023 03:31PM
Re: IF ELSE
Barry Galbraith
March 19, 2023 12:56AM
Re: IF ELSE
Michael Smith
March 22, 2023 01:34PM
Re: IF ELSE
Barry Galbraith
March 22, 2023 05:02PM
Re: IF ELSE
Michael Smith
March 22, 2023 07:21PM
Re: IF ELSE
Barry Galbraith
March 23, 2023 01:54AM
Re: IF ELSE
Barry Galbraith
March 26, 2023 06:24PM


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.