Introduction to MySQL

MySQL is an open-source Relational Database Management System that backed by Oracle. MySQL name is the combination of My and SQL. My states for the daughter’s name of MySQL’s co-founder, Monty Widenius, and SQL states for Structured Query Language.

Monty Widenius

MySQL is very easy to learn compared than other platforms like Oracle and MS SQL Server. You can setup MySQL in any platform like Windows, Linux and Unix based operating systems. Also you can integrate this with any programming language like Java, C#, python, Ruby, JavaScript etc.

Features of MySQL

  1. Easy to learn and use: MySQL is very easy to learn and use. By learning some queries, you can start using it.
  2. Most secured: MySQL has an extra data security layer that protects sensitive data from hacking. Also, passwords are encrypted in MySQL.
  3. Free download: You can download it from MySQL official website at free of cost.
  4. Very scalable: MySQL supports multi-threading that makes it very scalable. It can handle almost any amount of data. The default file size limit is about 4 GB. But you can increase this number to 8 TB of data. It’s really very scalable.
  5. High Flexibility: MySQL supports a almost all programming language that makes it very flexible.
  6. Platform Independent: You can use MySQL on most of the operating systems like Windows, Linux, MAC and Unix based operating systems.
  7. Allows role back: MySQL allows transactions to be rolled back, commit, and crash recovery.
  8. High Performance: MySQL is faster and high performance compared to other paid database management systems.
  9. High productivity: MySQL uses Triggers, Stored procedures, and views that allow the developer to give higher productivity.
about author

admin

salmansrabon@gmail.com

If you like my post or If you have any queries, do not hesitate to leave a comment.

Leave a Reply

Your email address will not be published. Required fields are marked *