Enum as a parameter in Procedure, how to do it ??
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.
Subject
Views
Written By
Posted
Enum as a parameter in Procedure, how to do it ??
11662
September 28, 2012 03:32AM
3677
October 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.