MySQL Simple introduction

Data types supported by MySQL

Data types supported by MySQL include tinyint, SMALLINT, mediumint, int or integer, BIGINT, FLOAT, double, double PRECISION, REAL, DECIMAL, NUMERIC, DATE, DATETIME, TIMESTAMP, time, year, CHAR, VARCHAR, Tinyblob, Tinytext, BLOB, TEXT, Mediumblob, Mediumtext, Longblob, Longtext, ENUM, SET.

Advantages of MySQL

• Use

  It is easy to install. Third-party tools, including visualization tools, make it easy for users to get started.

• Feature Rich

  MySQL supports most of the features that a relational database should have--either directly or indirectly.

• Safety

  Many security features are supported, some are very advanced, and are built into MySQL.

• Scalable and very powerful

  MySQL is capable of processing large amounts of data and can be used at scale when needed.

• Fast

  By giving up some standards, MySQL is able to work very efficiently and simply, and thus faster.

MySQL's drawbacks

• Known Limitations

  MySQL has no intention to do everything from the start, so it has some limitations in terms of functionality and does not meet the requirements of some advanced applications.

• Reliability issues

  MySQL's implementation of certain features, such as references, transactions, audits, and so on, makes it less reliable than other relational databases.

• Development stalled

  Although MySQL remains an open-source product, there has been a lot of complaining about the progress of the development since it was acquired. It is important to note that there are MySQL-based, fully integrated databases that have additional value added on top of standard MySQL, such as mariadb.

When should I use MySQL

• Distributed operations

  If SQLite does not meet your needs, then bring MySQL into the development stack, just like any other standalone database server, it can give you a lot of freedom of operation and some advanced features.

• High Security

  MySQL's security mechanism provides reliable protection for data access and use in a simple way.

• Web sites and Web Apps

  Despite some constraints, most Web sites and Web applications can simply run on MySQL. The associated flexible and extensible tools are very easy to use and manage-they prove useful for long-term operation.

• Tailor-made Solutions

  MySQL has a rich set of configuration items and operating modes, and if you need a highly tailored solution, then MySQL can easily follow and execute your rules.

When you should not use MySQL

• SQL Compliance

  Because MySQL does not intend to implement the full SQL standard, it does not fully conform to SQL. If you may need to integrate with such a relational database, it may not be easy to switch from MySQL to the past.

• Concurrency of

  Although MySQL and some other storage engines can perform very good read operations, concurrent read and write may be problematic.

• Missing features

  MySQL lacks certain features, such as full-text search.

MySQL Simple introduction