Recursion : Introduction : Procedure Function : SQL / MySQL examples (example source code) Organized by topic

SQL / MySQL 1.  Backup Load 2.  Command MySQL 3.  Cursor 4.  Data Type 5.  Database 6.  Date Time 7.  Flow Control 8.  Function 9.  Insert Delete Update 10.  Join 11.  Key 12.  Math 13.  Procedure Function 14.  Select Clause 15.  String 16.  Table Index 17.  Transaction 18.  Trigger 19.  User Permission 20.  View 21.  Where Clause Java Java Tutorial Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL MySQL Tutorial VB.Net VB.Net Tutorial

SQL / MySQL » Procedure Function » Introduction   Recursion   mysql> Functions and procedures can call themselves. mysql> mysql> delimiter $$ mysql> CREATE FUNCTION factorial(n BIGINT) RETURNS BIGINT     -> BEGIN     ->   IF n>=2 THEN     ->     RETURN n * factorial(n-1);     ->   ELSE     ->     RETURN n;     ->   END IF;     -> END$$ Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> mysql> mysql> SELECT factorial(3); ERROR 1424 (HY000): Recursive stored functions and triggers are not allowed. mysql> mysql> drop function factorial; Query OK, 0 rows affected (0.00 sec)          Related examples in the same category 1.  Using user-defined function in a select statement 2.  Use user-defined function in a select statement to deal with data in a table 3.  Use user-defined function in order by clause 4.  Use user-defined function in where clause

Home | Contact Us

Copyright 2003 - 07 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.