1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

In a property booking section want a query to check that
property is booked from StartDate to EndDate.Booking Table
field are given

id
proerty_id
start_date
checkout_date
no_of_visitor
booking date
status

Waiting yours answer..
Thanks In Advance...

Question Posted / judhisahoo


In a property booking section want a query to check that property is booked from StartDate to EndDa..

Answer / sudhanshu_kmr

select * from property_table where
to_days(bookingdate)> to_days(startdate) and to_days(bookingdate)< to_days(enddate) ;

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More MySQL Interview Questions

How does mysql store binary data?

0 Answers  

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

0 Answers  

What is max connections in mysql?

0 Answers  

How many mysql connections can handle?

0 Answers  

How to delete an existing column in a table?

0 Answers  




what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage

3 Answers   ABC,

How do you index just the first four bytes of the column?

2 Answers  

Why do we use group by and order by function in mysql?

0 Answers  

How do I edit a trigger in mysql?

0 Answers  

What is delimiter in mysql trigger?

0 Answers  

Is mysql port 3306 tcp or udp?

0 Answers  

How to write after insert event update trigger on the same table in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories