Open MySQL Workbench and connect to your database server. From the database home screen ( Figure A ), right-click a blank spot under the SCHEMAS pane and select Create Schema. Figure A ...

How to write this SQL Query (Hotels, Rooms, and Rates)? ... Its my understanding that MySQL doesn't support all of SQL92 - specifically I don't know how it deals with temp tables.