对表中varchar字段排序,用order by排序可能会不生效,改为order by (字段名+0)即可
// 对表中varchar字段排序
SELECT *
FROM student
WHERE stu_name = '测试'
order by (stu_no+0) asc
对表中varchar字段排序,用order by排序可能会不生效,改为order by (字段名+0)即可
// 对表中varchar字段排序
SELECT *
FROM student
WHERE stu_name = '测试'
order by (stu_no+0) asc