When you’re in an interview and suddenly asked: What’s the difference between MySQL and Oracle? What would you say? In fact, when the interviewer asks questions, they mainly want to test your understanding and proficiency of database, when to use mysql, when to use Oracle, what are the advantages and disadvantages of each! Take you to analyze the answer to this question below!

1. Oracle is a large database while Mysql is a small and medium-sized database. Oracle has a market share of 40% while Mysql only has about 20%.

2. Oracle is the best tool for OLTP because it supports large concurrency and large traffic.

3. The space used for installation is also very different. After Mysql is installed, it is only 152M, while Oracle has about 3G, and Oracle takes up a lot of memory space and other machine performance.

4. Differences between Oracle and Mysql in operation

Mysql > alter table autoincrement increment Mysql > alter table autoincrement increment Mysql > alter table autoincrement increment Mysql > alter table autoincrement increment Oracle does not have automatic growth type, the primary key is generally used in the sequence, when the record is inserted to pay the next value of the serial number to this field; The ORM framework is a native primary key generation strategy.

MYSQL can use double quotation marks around strings, ORACLE can only use single quotation marks around strings. Single quotes must be replaced before inserting and modifying strings, replacing all occurrences with two single quotes.

MYSQL MYSQL MYSQL MYSQL MYSQL MYSQL MYSQL MYSQL MYSQL MYSQL ORACLE handles page-turning SQL statements more cumbersome. Each result set has only one ROWNUM field to indicate its position, and only ROWNUM<100, not ROWNUM>80.

The handling of long strings is special to ORACLE as well. The maximum string length for INSERT and UPDATE operations is 4000 bytes or less. If you want to INSERT longer strings, consider using cloBS for fields and using DBMS_LOB from ORACLE. Before inserting the modified record, make sure to judge whether it is not empty or its length. If the field value cannot be empty or the field value exceeds the length, a warning should be given and the last operation should be returned.

(5) MYSQL does not allow null fields to be empty, ORACLE defines a non-empty field does not allow empty space. MYSQL > alter table table table NOT NULL If it is NULL or a NULL character, you need to change it to an empty lattice string.

MYSQL like’% string %’ MYSQL like’% string %’ MYSQL like’% string %’ MYSQL like’% string %’ MYSQL like’% string %’

⑦Oracle implements most of the functions in ANSII SQL, such as transaction isolation level, propagation features and so on, while Mysql is still relatively weak in this aspect.

MySQL and Oracle are popular relational database management systems that are widely used around the world. But according to their respective characteristics, there are great differences in use. As a developer, you need to use a database a lot. Is it MySQL or Oracle? It is necessary to prioritize the use of enterprise database requirements. Do you understand the difference between MySQL and Oracle?

In addition, for most of our small partners now programming do not know how to get started, how to lay a good foundation! The best time to plant a tree was ten years ago, followed by now. ** For those of you who are ready to learn programming, if you want to improve your core programming skills ** you might as well start now!

C language C++ programming learning exchange circle, **QQ group [614504899] ** wechat public number: C language programming learning base

Organize and share (years of learning source code, project actual combat video, project notes, basic introduction tutorial)

Welcome to change careers and learn programming partners, use more information to learn and grow faster than their own thinking oh!