Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013

    Unanswered: Compatibility Issues: MySQL and Oracle

    Hello guys, im wondering if you could help me with compatibility issues between MySQL and Oracle databases. im having trouble finding it anywhere else.

    Are they any Issues in compatibility, and if so what?

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    As MySQL has a lot of stupid behaviours (especially in a plain vanilla installation), there will be a lot of issues. Take the following statement:
    create table foo (start_date date);
    insert into foo (start_date) values (date '2013-02-31');
    This will work in a default MySQL installation but not in Oracle.

    The following code
    create table foo (some_value int, other_value int);
    insert into foo values (1,0);
    select sum(some_value)/sum(other_value)
    from foo;
    will work in MySQL, but in no other DBMS.

    The following statement will work in MySQL but not in Oracle
    create table foo (some_col varchar(64));
    insert into foo (some_col) values ('foobar');
    select * from foo where some_col = 2;
    This is just a short list I can immediately think of.
    There are a lot more of these things and it's impossible to give you a complete list.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags:

    Tips for good questions:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts