MySQL Forums
Forum List  »  Newbie

Re: Declare variable and set value
Posted by: erwin traas
Date: November 19, 2019 08:03AM

Hi,

thank you, it is still giving me a red cross on the last line (code below) !

This is the complete code :

DECLARE done boolean DEFAULT FALSE;
DECLARE werkpakketval varchar(10) DEFAULT '';
DECLARE i INT DEFAULT 1;
DECLARE z INT;
SET z = (select MAX(selectie) from Wp_plankaarten);

I confirmed the field and table names are correct ( even case sensitive )

The select command in the phpmyadmin console returns a value.

Am I missing something?

Regards
Erwin

Options: ReplyQuote


Subject
Written By
Posted
November 18, 2019 01:33PM
Re: Declare variable and set value
November 19, 2019 08:03AM


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.