select * from ding where ((starttime between '2017-05-04 20:00:00' and '2017-06-03') or (endtime between '2017-05-04 20:00:00' and '2017-06-03')) and Room_ID=5
本文标题: MySQL 解决会议室时间占用问题 文章分类:【MySQL】 非特殊说明,本文版权归【胡同里的砖头】个人博客 所有,转载请注明出处.
上一篇:spring +mybatis 出现The content of elements must consist of well-formed 下一篇: mysql varchar转datetime