Hejo,
Czy ktos moze mi wylumaczyc jak mniej wiecej dzialaja procedury w MySQL a w szczegolnosci w phpmyAdmin??
I probowalem napisac nastepujaca prcedure ale ciagle wywala mi blad?
DELIMITER $$
CREATE procedure while_ex()
block: BEGIN
DECLARE maxID INT;
DECLARE i INT;
declare value VARCHAR(20) default ' ' ;
SET i = 1;
WHILE i <= maxID DO
SET value = DATEDIFF('2002-04-02','1970-01-01');
SET i = i + 1;
END
WHILE block;
select value ;
END $$
DELIMITER ;
i blad.
Analiza statyczna:
1 errors were found during analysis.
Oczekiwano nazwy zmiennej. (near " " at position 35)
Zapytanie SQL: Copy Documentation
CREATE procedure while_ex() block: BEGIN DECLARE maxID INT; DECLARE i INT; declare value VARCHAR(20) default ' ' ; SET i = 1; WHILE i <= maxID DO SET value = DATEDIFF('2002-04-02','1970-01-01'); SET i = i + 1; END WHILE block; select value ; END;
MySQL zwrócił komunikat: Documentation
#1064 - Something is wrong in your syntax obok 'block;
select value ;
END' w linii 11
wytlumaczy ktos dlaczego i jak powinno byc porawnie??