Skip navigation links

MySQL Forums :: Stored Procedures :: Enum as a parameter in Procedure, how to do it ??


Advanced Search

Enum as a parameter in Procedure, how to do it ??
Posted by: Dody Marefandho ()
Date: September 28, 2012 03:32AM

Hi, I'm a newbie here :D, and I try to make a simple stored procedure using Enum as parameter, but it didn't work out ...,
if I can do this, maybe I can insert the value into some table. the value can look like this ('one','two','three')

Here's the query :

DELIMITER $$
DROP PROCEDURE IF EXISTS `schemaname`.`test` $$
CREATE DEFINER = `root`@`localhost`
PROCEDURE `schemaname`.`test`(data ENUM)
BEGIN
INSERT INTO `schemaname`.`tablename`(col2,col3,col4) VALUES (data);
END$$
DELIMITER ;

and the result is :
Script line: 3 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 ')


could anyone help??
thanks



Edited 1 time(s). Last edit at 09/28/2012 03:41AM by Dody Marefandho.

Options: ReplyQuote


Subject Views Written By Posted
Enum as a parameter in Procedure, how to do it ?? 2281 Dody Marefandho 09/28/2012 03:32AM
Re: Enum as a parameter in Procedure, how to do it ?? 856 Devart Team 10/01/2012 01:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.