使用MySql检查可用房间 [英] Checking Available Room Using MySql

问题描述

每个人.我在网上预订酒店时遇到问题，我的问题很难检查空房.所以我有很多像这样的表:

Everybody. I have a problem with my assignment about hotel booking online, that my problem is difficult to check available room. So I have many table like:

tbRoom(RoomID,RoomName,...)
tbReservation(ResID,ResDate,....)
tbReservationDetail(ResID,RoomID,ArrvialDate,DepartureDate,....)

我想在两个日期之间获得可用的房间.

I want to get Room that available in between two date.

那么，我该怎么办?还是我需要创建更多表?

so, How I do?or DO I need to create more table?

请帮助我，谢谢您的帮助....

Please help me, Thank for helping....

推荐答案

您可以选择保留的房间并反转:

You can select your reserved rooms and invert:

SELECT * FROM tbRoom WHERE RoomID NOT IN (SELECT RoomID FROM tbReservationDetail WHERE ArrvialDate < yourDate AND DepartureDate > yourDate)

这篇关于使用MySql检查可用房间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！