Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Database Articles
Page 201 of 547
Documenters and translators of MySQL
Let us see who the documenters and translators of MySQL are −Many people have contributed in the MySQL documentation, translation of the documentation and error messages in MySQL. There are many people, organizations, students, and others who have helped in the development, maintenance, and improvement of MySQL.But the major people who have supported in the documentation and translation of certain parts of MySQL by lending their never-ending support, along with their contributions have been listed below −Kim Aldale − They have helped rewrite Monty's and David's early attempts at English into English.Michael J. Miller Jr − They have helped in ...
Read MoreMajor Supporters of MySQL
Let us see who the major supports of MySQL are −Oracle Corporation and/or its affiliates own all copyrights of the MySQL server and the MySQL manual. There are many people, organizations, students, and others who have helped in the development, maintenance, and improvement of MySQL. Many companies have helped in the development of the MySQL server. This includes paying for developing a new feature or providing hardware for development of the MySQL server. They have been listed below −VA Linux / Andover.netThey helped with the funding of the replicationNuSphereThey helped with the editing of the MySQL manual.Stork Design studioIt was ...
Read MoreMySQL Differences from Standard SQL
Let us understand the differences between MySQL and Standard SQL. MySQL performs many operations differently in certain cases −PrivilegesThere are many differences between MySQL and standard SQL with respect to privileges given to the user. In MySQL, privileges for a table are automatically not revoked when a table is deleted. A REVOKE statement needs to be explicitly issued to revoke privileges for a table.Foreign Key ConstraintsThe MySQL implementation of foreign key constraints is different from the SQL standard. If there are many rows in the parent table with the same referenced key value, InnoDB engine does a foreign key check ...
Read MoreMySQL Extensions to Standard SQL
MySQL server supports extensions which may not be found in other SQL databases. This means, if these extensions of MySQL are used, the code can’t be ported to other SQL servers. But sometimes, it can be ported.Let us understand the MySQL extensions to standard SQL −Enclosing StringsThe strings can be enclosed in “ (double quotes) or ‘ (single quote) by default. If the ‘ANSI_QUOTES’ SQL mode is on, the strings have to be enclosed using ‘, and if “ (double quotes) is used, the server interprets this as identifiers.Escape Character\ is the escape character for strings.Accessing TableMySQL doesn’t support tablespaces, ...
Read MoreMySQL Standards Compliance
The standards compliance tells how MySQL is related to the ANSI/ISO SQL standards. There are many versions of the SQL standard, and the phrase ‘SQL standard’ is used to refer to the current version of SQL standard at any point in time.Following are the MySQL Standards Compliance −MySQL server was originally designed to work with medium-sized databases (10 to 100 million rows or 100 MB per table) on small systems. But currently, it has been upgraded to work with terabyte-sized databases.MySQL supports ODBC levels ranging from 0 to 3.5.1.MySQL also supports high-availability database clustering, which can be achieved with the ...
Read MoreDifferences between MySQL standard and MySQL Enterprise Servers
MySQL Enterprise EditionMySQL Enterprise Edition comes with advanced features, management tools, and technical support that helps users achieve the highest levels of MySQL scalability, security, reliability, and uptime. It reduces the risk, complication, and cost associated with development, deployment, and management of business-critical MySQL applications.MySQL Database Service is a fully managed database service that helps deploy cloud-native applications using the MySQL, which is considered as the world’s most popular open source database. It is completely developed, managed and supported by the MySQL Team.MySQL Standard EditionMySQL standard edition ensures that user delivers high-performance and provides scalability on OLTP applications (Online Transaction ...
Read MoreWhat are the new features in MySQL 8.0
MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages. It uses a standard form of the well-known SQL data language. MySQL 8.0 released on 19 April 2018 and the current version is 8.0.23.The new features in MySQL 8.0 have been briefly listed below:Atomic DDLAn atomic data definition language (DDL) statement to combine updates made to data dictionary, storage engine operations and so on.Encryption DefaultsThe encryption defaults have been defined and implemented globally for table encryption. The ‘default_table_encryption’ variable is used to define an ...
Read MoreWhat are the features that were deprecated in MySQL 8.0?
Some of the features that have been deprecated may be removed in the upcoming versions of MySQL. If applications use the features that have been deprecated in that specific version, that feature should be revised and alternatives should be used wherever possible.Let us understand in brief, the features that have been deprecated in MySQL 8.0:The ‘utf8mb3’ character set is deprecated, use ‘utf8mb4’ instead.The ‘sha256_password’ password authentication is deprecated, may be removed in future updates. Use ‘caching_sha2_password’ instead.Some implementation changes have been made to ‘validate_password’ plugin, may be removed in future versions. Use this plugin by ensuring that component infrastructure is ...
Read MoreWhat are the features that were removed in MySQL 8.0?
Some of the features have become obsolete and have been removed from MySQL 8.0. When alternatives to these removed items are shown, they need to be used to avoid further complications.The ‘innodb_locks_unsafe_for_binlog’ system variable has been removed.The ‘READ COMMITTED’ isolation level can be used since it behaves in a similar way.After upgrading the system to MySQL version 8.0.3 or later, scripts that reference previous InnoDB INFORMATION_SCHEMA view names have to be upgraded.Some of the account management attributes have been removed. A few have been listed below:Instead of using ‘GRANT’ to create users, use ‘CREATE USER’.The query cache has been removed.The deprecated ...
Read MoreWhat are the options and variables introduced in MySQL 8.0?
Some of the options and variables newly introduced in MySQL 8.0 have been listed below:Com_clone: It refers to the number of CLONE statements. It was added in MySQL 8.0.2.Com_create_role: It refers to the number of CREATE ROLE statements that are used. It was added in MySQL 8.0.0.Com_drop_role: It refers to the number of DROP ROLE statements that were used. It was added in MySQL 8.0.0.Com_restart: It refers to the number of RESTART statements that were used. It was added in MySQL 8.0.4.Firewall_access_denied: It refers to the number of statements that were rejected by MySQL Enterprise Firewall. It was added in ...
Read More