随笔分类 -  工程实践

【MySQL】SQL语法，between and 使用注意事项
摘要：业务代码中有条查询学生姓名的sql：select stu_name from stu_info where stu_id between id_1 and id_2;估计当时一时恍惚，拼接sql时 传参有误导致 id_1 > id_2，导致始终查询不到学生姓名。。。对于MySQL不检查between... 阅读全文
posted @ 2015-07-19 00:06 狂暴的水牛 阅读(3036) 评论(0) 推荐(0)