delimiter |
CREATE PROCEDURE `create_random_name`
(IN FK_Nation_ID_IN INT, IN Gender_IN INT,IN FK_Func_Cat_ID_IN INT)
BEGIN

/*****************************************************/
  DECLARE @NatID INTEGER;
  SET @NatID = FK_Nation_ID_IN;

  /* Wenn NatID = 0 dann eine zufällige existierende Nation erzeugen */
  IF @NatID = 0 THEN
  ( SELECT FK_Nation_ID
    INTO @NatID
    FROM names_ressources
    ORDER BY RAND(NOW())
    LIMIT 1
  );

/****************************************************/

  INSERT INTO names (LastName, GivenName, FK_Nation_ID, Gender, FK_Function_Category_ID)
    /* Namen aus names_ressources zusammensetzen */
    SELECT t1.Name, t2.Name, t1.FK_Nation_ID, t2.Gender, FK_Func_Cat_ID_IN
    FROM names_ressourcesx t1, names_ressources t2
    WHERE
    (   t1.FK_Nation_ID = @NatID
    AND t2.FK_Nation_ID = @NatID
    AND t1.Category = 1 /* LastName */
    AND t2.Category = 2 /* GivenName */
    AND t2.Gender=Gender_IN /*  */
    )
    ORDER BY RAND(NOW()) LIMIT 1;
END;
|

delimiter |
CREATE PROCEDURE `create_random_name`
(IN FK_Nation_ID_IN INT, IN Gender_IN INT,IN FK_Func_Cat_ID_IN INT)
BEGIN

  DECLARE NatID INT;
  SET NatID = FK_Nation_ID_IN;

  /* Wenn NatID = 0 dann eine zufällige existierende Nation erzeugen */
  IF NatID = 0 THEN
  ( SELECT FK_Nation_ID
    INTO NatID
    FROM names_ressources
    ORDER BY RAND(NOW())
    LIMIT 1
  );

  INSERT INTO names (LastName, GivenName, FK_Nation_ID, Gender, FK_Function_Category_ID)
    /* Namen aus names_ressources zusammensetzen */
    SELECT t1.Name, t2.Name, t1.FK_Nation_ID, t2.Gender, FK_Func_Cat_ID_IN
    FROM names_ressourcesx t1, names_ressources t2
    WHERE
    (   t1.FK_Nation_ID = NatID
    AND t2.FK_Nation_ID = NatID
    AND t1.Category = 1 /* LastName */
    AND t2.Category = 2 /* GivenName */
    AND t2.Gender=Gender_IN /*  */
    )
    ORDER BY RAND(NOW())
    LIMIT 1;
END;
|