MSSQL Server database tutorial stored procedures converted into MySQL tutorial database
DELIMITER $$
DROP PROCEDURE IF EXISTS changesequence$$
CREATE PROCEDURE changesequence
(
_sign INT,--0: Move up 1: Move Down
Table Name of TableName VARCHAR (m),--
ItemName VARCHAR,--primary key field name
ItemID INT,--primary Key ID
Sortname VARCHAR (50),--Sort ID
TypeName VARCHAR (50),--category field name
Typevalue VARCHAR (50)--Classification value
)
BEGIN
DECLARE _sql VARCHAR (4000);
DECLARE Thissort INT;
DECLARE Previd INT;
DECLARE NextID INT;
DECLARE _count INT;
CREATE Temporary TABLE _tab
(
_itemid INT,
_sort INT
);
SET _sql=concat (' INSERT into _tab (_itemid,_sort) SELECT ", Itemname,sortname, ' from ', TableName);
IF (typename<> ' and typevalue<> ') THEN
SET _sql=concat (_sql, ' where ', TypeName, ' = ', typevalue);
End IF;
SET _sql = CONCAT (_sql, ' ORDER by _sort ASC ');
SET @v_sql =_sql;
PREPARE stmt from @v_sql;
EXECUTE stmt;
Deallocate PREPARE stmt;
SET _sql = ';