将MySQL查询转换为HSQLDB和Oracle查询 [英] Translating MySQLqueries into HSQLDB and Oracle queries

问题描述

我有很多可以在MySQL中正确执行的工作查询.我还将在hsqldb和oracle中都需要这些语句.

I have got a bunch of working queries which can be executed correctly in MySQL. I would also need those statements in both hsqldb and oracle.

有许多教程可以教您如何从头开始为hsqldb和oracle创建查询，但是它们并没有说明如何直接转换查询.

There are number of tutorials which teach you how to create queries for hsqldb and oracle from scratch but they haven't explained how to translate the queries directly.

您建议我做什么?

如果查询已翻译，我是否可以测试它们?我无法直接测试查询，因为我只有MySQL.

If the queries were translated, would there be a way for me to test them? I cannot test the queries directly because I only have MySQL available.

推荐答案

如果可以确定所有目标数据库都符合ANSI SQL，则可以使用Mimer在线语法检查器.它是免费的(据我所知). 了解更多.

If you are certain that all your target databases are compliant with ANSI SQL you can use use the Mimer online syntax checker. It's free (as far as I can tell). Find out more.

如果您想进行转换，这将无济于事. MySQL limit等同于Oracle(where rownum <=)或HSQLDB(limit或top).

This won't help you if you want to convert e.g. MySQL limit to the equivalent in Oracle (where rownum <=) or HSQLDB (limit or top).

这篇关于将MySQL查询转换为HSQLDB和Oracle查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！