in a stored procedure i know you can create tables or database or schema, but is it possible to create a function or a view:
here is what i tried:
create PROCEDURE schemaName.asd()
DECLARE stmt VARCHAR(255);
SET stmt := concat('CREATE FUNCTION schemaName.asdsfasdf() RETURNS int BEGIN return 1; end;');
PREPARE stmt FROM @stmt;
when i do
and i get an ERROR CODE 1064
is it possible to create here functions or views?
if yes how can it be done?
if this can be done a simple example would be just fine
(i have mysql v5.1)
Edited 6-Dec-12 5:22am
i found out that you can't, maybe in the future mysql will have this functionallity.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)