Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE RESERVAS (
- idreserva INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
- idcabana INT NOT NULL,
- idemail VARCHAR(50) NOT NULL,
- check_in DATE NOT NULL,
- check_out DATE NOT NULL,
- FOREIGN KEY (idcabana) REFERENCES CABANAS(idcabana),
- FOREIGN KEY (idemail) REFERENCES CLIENTES(idemail)
- );
- INSERT INTO RESERVAS (idreserva, idcabana, idemail, check_in, check_out) VALUES
- (1, 1, "d@hotmail.com", "2017/03/15", "2017/03/18"),
- (2, 1, "c@hotmail.com", "2017/03/20", "2017/03/22"),
- (3, 2, "c333@hotmail.com", "2017/04/05", "2017/04/18"),
- (4, 2, "sar@hotmail.com", "2017/06/23", "2017/06/25"),
- (5, 3, "de@hotmail.com", "2017/06/07", "2017/06/18"),
- (6, 3, "daasda@hotmail.com", "2017/08/16", "2017/08/30");
- SELECT idreserva FROM reservas
- where (check_in>='2017/03/17' OR check_in<='2017/03/17') AND (check_out>='2017/03/19' OR check_out<='2017/03/19');
Add Comment
Please, Sign In to add comment