Trouble creating a function in MySQL

Question

I'm used to working in MS SQL Server, so MySQL is always a little bit foreign to me. I wrote the following for MS SQL Server, and I'm trying to port it to MySQL:

CREATE FUNCTION ToRadians
(@Degrees float)
RETURNS float
AS
BEGIN
  DECLARE @Radians float
  SELECT @Radians  = @Degrees * 3.1415927 / 180
  RETURN @Radians
END
GO

I've got

CREATE FUNCTION ToRadians
(@Degrees float)
RETURNS float
BEGIN
  DECLARE @Radians float;
  SELECT @Radians  = @Degrees * 3.1415927 / 180;
  RETURN @Radians;
END

but in PHPMyAdmin, that gives me the error:

Error

SQL query:

CREATE FUNCTION ToRadians(
@Degrees float
) RETURNS float AS BEGIN DECLARE@Radians float;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@Degrees float)
RETURNS float
AS
BEGIN
DECLARE @Radians float' at line 2

The searching I've done indicates that the above MySQL UDF should be correct, but it obviously isn't. SELECT version() returns 5.0.77

Ben English · Accepted Answer · 2011-11-14 18:54:38Z

1

CREATE FUNCTION ToRadians (in_degrees FLOAT) RETURNS FLOAT
DETERMINISTIC
BEGIN
    RETURN in_degrees * 3.1415927 / 180;    
END;

DETERMINISTIC because the return for a given value of degrees should always be the same in radians.

Also DEGREES() and RADIANS() functions already exist in mysql. RADIANS()

edited Nov 14, 2011 at 18:54

answered Nov 14, 2011 at 14:53

Ben English

3,9382 gold badges26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chris Over a year ago

I did not know that function existed. Fancy.

a1ex07 · Accepted Answer · 2011-11-14 14:45:49Z

0

Don't use @ in MySQL variable names, it creates a local session variable.
You probably need to change standart delimiter which is semicolon to another character, for instance // : DELIMITER // before your function definition, then // just after function, then switch delimiter back to semicolon (DELIMITER ;)

answered Nov 14, 2011 at 14:45

a1ex07

37.4k12 gold badges93 silver badges103 bronze badges

2 Comments

Chris Over a year ago

Also, it turns out I can't use SELECT to do math within a function. I should have been using SET Radians = Degrees * 3.1415927 / 180;

a1ex07 Over a year ago

You could also do SELECT ... INTO [variable]…

Collectives™ on Stack Overflow

Trouble creating a function in MySQL

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related