MySQL Forums
Forum List  »  Stored Procedures

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 ??
11662
September 28, 2012 03:32AM


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.