将oracle查询迁移到mysql查询 [英] Migrating the oracle query to mysql query

问题描述

Hai all，



目前我在我的应用程序中使用 ORACLE 。但我们有一些小规模公司作为客户，所以我们计划为这些客户使用 MYSQL 。所以想得到一些建议来概括可以在ORACLE和MYSQL中执行的现有查询。





在此先感谢



我尝试了什么：



我开始更换语法EVL到IFNULL，但我们不能替换所有这样的语法。

Hai all,

At present I am using the ORACLE in my application. But we have some small scale companies as a clients so we planned to use MYSQL for those clients. So would like to get some suggestions to generalize the existing queries which can be executed in both ORACLE and MYSQL.


Thanks in Advance

What I have tried:

I started to replace the syntax like EVL to IFNULL, but we can not replace all the syntax like this.

推荐答案

你需要的只是编写可移植的数据访问层。请参阅：编写可移植数据访问层 [ ^ ]

All what you need is to write portable Data Access Layer. See: Writing a Portable Data Access Layer[^]

这篇关于将oracle查询迁移到mysql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！