MySQL limitations - What are the limitations of mysql in Comparison of Oracle?

What are the limitations of mysql in Comparison of Oracle?

1. Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
2. Large Database size is supported more in Oracle in contrast to MySql.

MySQL vs. Oracle.

1. Unlike oracle, mysql data types can store invalid dates and don’t support time zones.
2. Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0.
3. Large Database size is supported more in Oracle in contrast to MySql.
4. Replication in oracle is two way while one way in mysql.
MySQL Trigger - What is a Trigger in MySQL? Define different types of Trigger?
MySQL Trigger - A trigger is a set of code which is executed in response to some event.....
MySQL - What is the difference between CHAR_LENGTH and LENGTH?
MySQL CHAR_LENGTH and LENGTH - The basic difference between RPC and JMS lies in the way they message. RPC uses synchronous messaging....
MySQL - Explain the difference between BOOL, TINYINT and BIT.
The basic difference between RPC and JMS lies in the way they message. RPC uses synchronous messaging....
Post your comment

Related Content

Follow us

▲