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 ...

An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.

There are plenty of GUI tools available that can manage your MySQL database, even from the Windows environment.