select *,len(b)-len(replace(b,char(13),''))+1 as 行数 from ( select 1 as a,'1' as b union all select 2 as a,'1 2' as b union all select 3 as a,'1 2 3' as b ) as t
select len(replace(字段名,char(13),''))+1 as 行数 from 表名
select len(字段)-len(replace(字段,char(13),''))+1 from table
from (
select 1 as a,'1' as b
union all
select 2 as a,'1
2' as b
union all
select 3 as a,'1
2
3' as b
) as t
from 表名