1

I am trying to create a dynamic function using mysql, And getting error. How can i solve it.

CREATE function updateTable(user_name Varchar(50), item_name Varchar(50), item_val Varchar(50)) RETURNS int
    BEGIN
    SET @item_val = item_val;
    SET @item_name = item_name;
    SET @user_name = user_name;
    IF @item_val = '' THEN
    SET @myCommand = concat('UPDATE table SET @item_name = null , row_modified =  CURRENT_TIMESTAMP WHERE user_id = @user_name;');
    PREPARE stmt FROM @myCommand;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
    ELSE
    SET @myCommand = concat('UPDATE table SET @item_name = @item_val , row_modified =  CURRENT_TIMESTAMP WHERE user_id = @user_name;');
    PREPARE stmt1 FROM @myCommand;
    EXECUTE stmt1;
    DEALLOCATE PREPARE stmt1;
    END IF;
    RETURN 1;

    END;
Ojen
  • 817
  • 12
  • 23
san
  • 11
  • 2

0 Answers0