
To get into MYSQL:

	mysql -u cp3003 -h emu.cs.jcu.edu.au -p
	cp3003-password

Commands:
	
	show databases;
	use room;
	show tables;


	select DISTINCT date from booking ORDER BY date ASC;
	https://manning.cs.jcu.edu.au/~jc130551/dbn.php


SELECT *
FROM booking, person
WHERE booking.person = person.name AND booking.date = "2003-03-24"
ORDER BY time, person ASC;