Oracle has recently announced the general availability of MySQL 8.2, which includes support for Read/Write Splitting. This long-awaited feature has been introduced in the latest innovation release ...

and a.RoomType = b.RoomType; </pre><BR>I believe that's SQL92. Its my understanding that MySQL doesn't support all of SQL92 - specifically I don't know how it deals with temp tables.

If you plan to do database development with Java and MySQL, the first thing you’ll need to do is configure a database schema. Technically speaking, the first thing to do before you configure a schema ...