56,677
社区成员
发帖
与我相关
我的任务
分享
declare nMax int;
select nMaxId = count(*) from 表; -- 无法
declare @nMax int
select @nMax = count(*) from 表
set @nMaxId = ( select count(*) from tb );
set @nMaxId = 0;
select count(*) into @nMaxID from tb limit 1;
declare nMax int;
select nMaxId := count(*) from 表;
set @nMax = 0;
select count(*) into @nMax from tb;
select @nMax; -- 还是0
declare nMax int;
select nMaxId := count(*) from 表;
declare nMax int;
select nMaxId := count(*) from 表;