Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What is the difference between access and mysql

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

This article mainly introduces what is the difference between access and mysql, which can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The difference between access and mysql:

(1) Mysql is an open source project supported by Oracle, while access is a very small database of microsoft, which requires a fee. Of course, what we have now is pirated, so it is free, but this pirated access cannot be used for commercial purposes.

(2) emphasize that any database can be connected in "language", so both mysql and access can be connected in languages such as Cppjore, java, python, etc. The method is simple. If you take java as an example, there are three ways to connect to a database.

(3) to be clear, many people think that mysql is used to do those small projects, in fact, it can also do large projects, ha, mysql is still very professional, for example: facebook uses mysql, it now uses 180000 hosts to support 900 million users, you can see how mysql is.

(4) if you want to specialize in a higher-level database, it is recommended to learn DB2 directly. At that time, if you can get the DBA of DB2, it is estimated that at current prices, the annual salary will not be less than 7 figures.

In short, the difference between access and mysql is:

1.mySql is a real database, which can process data dynamically and automatically.

2.Access provides a file service, so you can't process data dynamically.

Thank you for reading this article carefully. I hope the editor will share what the difference between access and mysql is helpful to everyone. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are 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.

Views: 243

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report