MySql Stored Procedure Example / Gaurang Jadia

DELIMITER $$

CREATE DEFINER=`root`@`%` PROCEDURE `GetAllFiles`(
	IN sort VARCHAR(4)
)
BEGIN
SET @orderBy = sort;

SET @sqlStatement = concat('
	SELECT
		id,
		name,
		path,
		type,
		size,
		ispublic,
		code,
		insertdate
	FROM
		File
	ORDER BY
		insertdate' + @orderBy + ';
');

PREPARE statement FROM @sqlStatement;
EXECUTE statement;
DEALLOCATE PREPARE statement;

END

DELIMITER $$

CREATE DEFINER=`root`@`%` PROCEDURE `GetAllFiles`(

IN sort VARCHAR(4)

)

BEGIN

SET @orderBy = sort;

SET @sqlStatement = concat('

SELECT

id,

name,

path,

type,

size,

ispublic,

code,

insertdate

FROM

File

ORDER BY

insertdate' + @orderBy + ';

');

PREPARE statement FROM @sqlStatement;

EXECUTE statement;

DEALLOCATE PREPARE statement;

END

Gaurang Jadia

Nothing is permanent except change

MySql Stored Procedure Example

Leave a Reply