后来我解决了这个问题 我发现order by 必须用两个以上的字段才行,一个就会出现问题 我用的是新的存储过程 insert into tjxmbao values(1,'','ddd','ddd','') insert into tjxmbao values(2,'','ddd','ddd2','') insert into tjxmbao values(3,'','ddd','ddd3','') insert into tjxmbao values(4,'','ddd','ddd4','') insert into tjxmbao values(5,'','ddd','ddd5','') insert into tjxmbao values(6,'','ddd','ddd6','')
我发现order by 必须用两个以上的字段才行,一个就会出现问题
我用的是新的存储过程
insert into tjxmbao values(1,'','ddd','ddd','')
insert into tjxmbao values(2,'','ddd','ddd2','')
insert into tjxmbao values(3,'','ddd','ddd3','')
insert into tjxmbao values(4,'','ddd','ddd4','')
insert into tjxmbao values(5,'','ddd','ddd5','')
insert into tjxmbao values(6,'','ddd','ddd6','')