MySQL Forums
Forum List  »  Spanish

Error 1064 Linea 1
Posted by: Carlos Navarro Tabares
Date: October 01, 2024 08:01AM

CREATE DEFINER=`root`@`localhost` PROCEDURE `PR_Prueba`(INOUT `Salida` BIGINT, IN `Cond1` CHAR(10))
LANGUAGE SQL
NOT DETERMINISTIC
MODIFIES SQL DATA
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE CSql varchar(100);
SET CSql = CONCAT('SELECT Count(*) INTO @Salida FROM ',Cond1,';');
PREPARE Linea FROM @CSql;
EXECUTE Linea;
SELECT @Salida INTO Salida;
DEALLOCATE PREPARE Linea;
END

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 1064 Linea 1
610
October 01, 2024 08:01AM


Sorry, only registered users may post in this forum.

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.