The article lists some of the tools that have been used to create MySQL. This is an important list which has helped mould what MySQl is today.Free Software FoundationThey helped provide an excellent compiler (gcc), an excellent debugger (gdb) and the libc library (from which strto.c has been borrowed to get some code working in Linux).Free Software Foundation & The XEmacs development teamThey have helped provide a really great editor/environment.Julian SewardThey are the author of valgrind, an excellent memory checker tool that helps find a lot of otherwise hard to find bugs in MySQL.Dorothea Lütkehaus and Andreas ZellerThey have helped ... Read More

Let us see the major packages that support MySQL −This article lists the creators and maintainers of some of the most important API/packages/applications that is used by a lot of people along with the usage of MySQL. The major packages that support MySQL by lending their support, along with their contributions have been listed below −Tim Bunce, Alligator Descartes: They helped with the DBD (Perl) interface.Andreas Koenig: They helped with the Perl interface for MySQL Server.Jochen Wiedmann: They helped in maintaining the Perl DBD::mysql module.Eugene Chan: They helped in porting PHP for MySQL Server.Georg Richter: They helped in the testing ... Read More

Let us see who the major contributors to MySQL are −Although Oracle Corporation and/or its affiliates own all copyrights in the MySQL server and the MySQL manual, we wish to recognize those who have made contributions of one kind or another to the MySQL distribution. Contributors are listed here, in somewhat random order −Gianmassimo Vigazzola − They helped with the initial port to Win32/NT.Per Eric Olsson − They provided for constructive criticism and real testing of the dynamic record format.Irena Pancirov − Helped with the Win32 port with Borland compiler. They also helped with the mysqlshutdown.exe and mysqlwatch.exe.David J. Hughes ... Read More

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 More

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 More

Let us understand how MySQL deals with constraints −MySQL helps us work with transactional tables (which permit rollback) and with non-transactional tables (which don’t permit rollback). This is the reason why handling constraints is different in MySQL in comparison to other DBMS. In non-transactional database, if an error occurs while inserting or updating many rows, it can’t be rolled back. This case has to be handled in the right manner.MySQL Server produces an error for queries which it detects to be errors, when parsing a statement that needs to be executed. Once the error has been detected, it tries to ... Read More

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 More

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 More

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 More

What is a bug?A bug is something that results in the program stalling or halting abruptly. This results in anomalies and causes complications, resulting in the task not getting complete. MySQL helps resolve these bugs, once they are reported.Some bugs have fixes since they would have been previously reported, and fixes would have been provided.Pre-requisitesBefore posting a bug report, it is important to verify that the bug hasn’t been reported already. For this purpose, look for the problem in the MySQL manual at https://dev.mysql.com/doc/. The manual is always updated with solutions to newly found issues.If there is a parsing error ... Read More