在一个存储过程里,可以这样
SET @num0=0;
select (@num0:=IFNULL(@num0,0) + 1) as NID,GroupID from t_ttt;但是这样就通不过
DECLARE _num0 int DEFAULT 0;
select (_num0:=IFNULL(_num0,0) + 1) as NID,GroupID from t_ttt;为啥呢?
SET @num0=0;
select (@num0:=IFNULL(@num0,0) + 1) as NID,GroupID from t_ttt;但是这样就通不过
DECLARE _num0 int DEFAULT 0;
select (_num0:=IFNULL(_num0,0) + 1) as NID,GroupID from t_ttt;为啥呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货