MySQL CREATE FUNCTION Syntax

by

You have to override your ; delimiter with something like $$ to avoid this kind of error.

After your function definition, you can set the delimiter back to ;.

This should work:

DELIMITER $$
CREATE FUNCTION F_Dist3D (x1 decimal, y1 decimal) 
RETURNS decimal
DETERMINISTIC
BEGIN 
  DECLARE dist decimal;
  SET dist = SQRT(x1 - y1);
  RETURN dist;
END$$
DELIMITER ;

More Related Contents:

  1. How to raise an error within a MySQL function
  2. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  3. Which DB technology is sued to solve the following search issue? [closed]
  4. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  5. How do you set a default value for a MySQL Datetime column?
  6. Select last row in MySQL
  7. Implementation of Levenshtein distance for mysql/fuzzy search?
  8. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  9. MySQL – Operand should contain 1 column(s)
  10. Restore table structure from frm and ibd files
  11. Can a number be used to name a MySQL table column?
  12. mysql pivot/crosstab query
  13. MySQL: Split comma separated list into multiple rows
  14. UNION query with codeigniter’s active record pattern
  15. How to start MySQL with –skip-grant-tables?
  16. When to use MongoDB or other document oriented database systems? [closed]
  17. Remove Primary Key in MySQL
  18. Difference in MySQL JOIN vs LEFT JOIN
  19. Update a column in MySQL
  20. MySql views performance [closed]
  21. What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?
  22. Invalid default value for ‘create_date’ timestamp field
  23. Detecting locked tables (locked by LOCK TABLE)
  24. MySQL Error: Incorrect usage of UPDATE and LIMIT
  25. How do you stop MySQL on a Mac OS install?
  26. Replace null with 0 in MySQL
  27. What’s mysql’s “BETWEEN” performance over..?
  28. MySQL: set field default value to other column
  29. Deleting a row based on the max value
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment