Shulou(Shulou.com)06/02 Report--

This article mainly introduces what is the difference between MySQL and Orcale database, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

1. Primary key difference: MySQL primary key generally uses automatic growth type, Orcale does not have automatic growth type, primary key generally uses sequence

Single quote processing: MySQL can use double quotes to wrap strings, ORA must use single quotes

Page turning: MySQL limit keyword start position, record number;Orcale rownum80.

String fuzzy comparison: MySQL like '% string %', Orcale can also be used but does not use the index, the speed is not fast, using the string comparison function instr(field name,' string')>0 will get more accurate search results.

Date field processing:

MYSQL date field is divided into DATE and TIME, ORACLE date field only DATE

2. Concurrency

MySQL: MySQL mainly uses table-level locks, and the granularity of resource locking is very large. If a session locks a table for too long, other sessions will not be able to update the data in this table.

Although innodb can use row-level locking, the mechanism for row-level locking depends on the index of the table. If the table has no index, or the SQL statement does not use an index, then table-level locking is still used.

Orcale: Orcale uses row-level locking, the granularity of resource locking is much smaller, only locking the resources required by sql, and locking is on the data rows in the database, independent of indexes. So Orcale's concurrency support is much better.

Thank you for reading this article carefully. I hope that the article "What is the difference between MySQL and Orcale database" shared by Xiaobian will be helpful to everyone. At the same time, I hope that everyone will support you a lot and pay attention to the industry information channel. More relevant knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.