使用php-activerecord中的`query（）`方法的查询在迁移时是否有效？

Question

Lets say i am launching a query with MySQL syntax using PHPActiverecord's Model::query() and in project deployment phase, target SQLServer will be Oracle.

I wonder to know does my query in MySQL still valid at deployment?

Answer 1

I wonder to know does my query in MySQL still valid at deployment?

It depends.

Mysql and Oracle has different SQL dialects.
If you are going to use two databases, then you should avoid raw queries, as most likely you will run into incompatible statement errors.

To offer compatibility is one of the AR purposes. That's why you should use only AR methods and avoid running raw queries.