very easy function in mysql doesn't work

chomik · #1 (**permalink**) 08-28-09, 13:06

MySQL 5.0.45

Code:

CREATE FUNCTION fun() RETURNS INT
BEGIN
RETURN 5;
END;

#1064 - Something is wrong in your syntax near '' in line 3

Why ?

r937 · #2 (**permalink**) 08-28-09, 13:57

Code:

DELIMITER $$

CREATE FUNCTION fun() RETURNS INT
BEGIN
RETURN 5;
END;

$$

chomik · #3 (**permalink**) 08-28-09, 14:30

Code:

DELIMITER $$ 

CREATE FUNCTION fun() RETURNS INT 
BEGIN RETURN 5; 
END; 

$$

I have still error:
http://img526.imageshack.us/my.php?i...2009203229.png
Imageshack - 08282009203042

BettingSherlock · #4 (**permalink**) 08-28-09, 16:17

Possibly you can't do that through phpadmin,
try connecting direct or use a script outside phpadmin.

chomik · #5 (**permalink**) 08-29-09, 03:46

PEOPLE !! I know !! You must write in phpmyadmin:

Code:

CREATE FUNCTION fun5() RETURNS INT 
BEGIN 
RETURN 5; 
END

without $$ in code !! And then write below in input Separator $$
Screen: http://yfrog.com/5r57844448j

And how can I see the result this function using php. It:

PHP Code:


			
$query = mysql_query("select fun()");
echo $query;

Shows me: Resource id #3 :/

Internet Services

Web Development

Digital Marketing

Consumer Tech