Re: Creating Functions and Procedures from the program

[Fernando Gonzalez]

Hi,

You cannot create stored routines inside another stored routine.

You cannot create them in C# using MySqlCommand neither, but can use MySqlScript, a sample follows:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace MyWorkbench
{
class Program
{
static void Main(string[] args)
{
MySqlConnection con = new MySqlConnection("<your connection string here");
con.Open();
MySqlScript scr = new MySqlScript( con );
scr.Delimiter = "//";
scr.Query = @"drop procedure if exists spCreator //
create procedure spCreator()
begin

set @s = 'select 1;';
prepare stmt1 from @s;
execute stmt1;
deallocate prepare stmt1;

end //";
scr.Execute();
con.Close();
}
}
}


In this sample, the stored procedure is using prepared statements, but it can be just about anything allowed in MySql server itself.

Thanks.