互联网服务触发器
查看其它 3 个回答villager的回答
IFAQ 里有个配套设置seed
CREATE PROCEDURE sp_setseed(n INTEGER)
DEFINE GLOBAL seed DECIMAL(10) DEFAULT 1;
LET seed = n;
END PROCEDURE;
global 值是跟session 的。
A global variable has its value stored in memory and is available to other SPL routines, run by the same user session, on the same database. A global variable has the following characteristics:
It requires a default value.
It can be used in any SPL routine, although it must be defined in each routine in which it is used.
It carries its value from one SPL routine to another until the session ends.
CREATE PROCEDURE sp_setseed(n INTEGER)
DEFINE GLOBAL seed DECIMAL(10) DEFAULT 1;
LET seed = n;
END PROCEDURE;
global 值是跟session 的。
A global variable has its value stored in memory and is available to other SPL routines, run by the same user session, on the same database. A global variable has the following characteristics:
It requires a default value.
It can be used in any SPL routine, although it must be defined in each routine in which it is used.
It carries its value from one SPL routine to another until the session ends.
浏览1033