What is MySQL and why it is used? and what's new in MySQL 8.0

In this tutorial learn more about what is MySQL and why need to use for the website, and what's new in MySQL 8.0 version.

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).most popular and highly-trafficked websites in the world rely on MySQL. SQL is the most popular language for adding, accessing and managing content in a database.


The following features have been added to MySQL 8.0:

• Character set support

       The default character set has changed from latin1 to utf8mb4.

• JSON enhancements

       Added the JSON utility function JSON_PRETTY(), which outputs an existing JSON value in an easy-to-read format, each JSON object member or array value is put on a separate line, and a child object or array is intended 2 spaces with respective to its parent. This function works with a string that can be parsed as a JSON value.

• Data type support.

       The use of expressions as default values for the BLOB, TEXT, GEOMETRY, and JSON data types, which previously could not be assigned default values at all. 

• Common table expressions.
• Window functions

        MySQL now supports window functions These include functions such as RANK(), LAG(), and NTILE(). In addition,  aggregate functions now can be used as window functions (example, SUM() and AVG()).

• Lateral derived tables. 
• Aliases in single-table DELETE statements. 
• regular expression support.
• Internal temporary tables
• Logging. 
• Backup lock.

       The new backup lock is supported by LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE syntax. The BACKUP_ADMIN privilege is required to use these statements.

• AND More