mysql用户自定义变量分为_mysql 用户自定义变量详解

这详细的介绍了怎么使用自定义变量

set @rownum:=0;

select disease,rn,@rownum,@rownum:[email protected]+1 as cmt from disease_code

where @rownum <=1

结果：

diseasern@rownumcmt

0020011001

0020031112

总结： 本次查询中，首先执 where ,再执行 select

二、

set @rownum:=0;

select disease,rn,@rownum,@rownum:[email protected]+1 as cmt from disease_code

where @rownum <=1

order by rn

结果：

diseasern@rownumcmt

0020011001

0020031112

0020021223

0020041334

0030012045

0030022156

0010013067

0010023178

0010033289

00400240910

004003411011

004004421112

004001431213

012001501314

008001601415

010001701516

007001801617

011003901718

011001911819

011002921920

011004932021

0060011002122

0050011102223

0050021112324

0050031122425

0090011202526

0130011302627

0140011402728

0150011502829

0160011602930

查询：

set @rownum:=0;

select disease,rn,@rownum,@rownum:[email protected]+1 as cmt from disease_code

where @rownum <=1

order by rn,@rownum

结果：

0020011001

0020031112

总结，第2个例子我现在也不明白，为什么，一个排序的差别，结果有这么大的区别。