NationMaster - Encyclopedia: MySQL

MySQL (pronounced (IPA) /mɑɪ ɛs kjuː ɛl/, "my S-Q-L"^[1]) is a multithreaded, multi-user SQL database management system (DBMS)^[2] which has, according to MySQL AB, more than 10 million installations.^[3] The basic program runs as a server providing multiuser access to a number of databases. Image File history File links MySQL.svgâ€Ž MySQL AB logotype Summary This is the scaleable version of MySQL.png that is in SVG format. ... â€œSoftware developmentâ€ redirects here. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... Code complete redirects here. ... is the 185th day of the year (186th in leap years) in the Gregorian calendar. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era in the 21st century. ... Code complete redirects here. ... is the 267th day of the year (268th in leap years) in the Gregorian calendar. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era in the 21st century. ... An operating system (OS) is the software that manages the sharing of the resources of a computer and provides programmers with an interface used to access those resources. ... A cross-platform (or platform independent) programming language, software application or hardware device works on more than one system platform (e. ... Computer software can be organized into categories based on common function, type, or field of use. ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ... A software license is a legal agreement which may take the form of a proprietary or gratuitous license as well as a memorandum of contract between a producer and a user of computer software. ... GPL redirects here. ... A website (alternatively, Web site or web site) is a collection of Web pages, images, videos or other digital assets that is hosted on one or several Web server(s), usually accessible via the Internet, cell phone or a LAN. A Web page is a document, typically written in HTML... For the form of code consisting entirely of subroutine calls, see Threaded code. ... Multi-user is a term that defines an operating system that allows concurrent access by multiple users of a computer. ... SQL (IPA: or ) is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ... A database management system (DBMS) is computer software designed for the purpose of managing databases. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ...

MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the copyright to most of the codebase. This is similar to the JBoss model. It is dissimilar to the Apache project, where the software is developed by a public community and the copyright to the codebase is owned by its individual authors. Some industry observers believe MySQL will file for an IPO in early 2008. MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... JBoss (pronounced Jay Boss) is an open source Java EE-based application server implemented in Java. ... The Apache HTTP Server, commonly referred to simply as Apache, is a web server notable for playing a key role in the initial growth of the World Wide Web. ... Wikipedia does not yet have an article with this exact name. ...

The company develops and maintains the system, selling support and service contracts, as well as proprietary-licensed copies of MySQL, and employing people all over the world who collaborate via the Internet. MySQL AB was founded by David Axmark, Allan Larsson, and Michael "Monty" Widenius. The CEO is Mårten Mickos. In software engineering, software maintenance is the process of enhancing and optimizing deployed software (software release), as well as remedying defects. ... This article is about a term used in economics. ... A contract is a legally binding exchange of promises or agreement between parties that the law will enforce. ... Proprietary software is software with restrictions on copying and modifying as enforced by the proprietor. ... David Axmark is one of the founders of MySQL AB and a developer of the Free Software database server, mysqld. ... Michael Widenius (often called Monty Widenius) is a Finnish author of the original version of the open-source MySQL database and a founding member of the MySQL AB company. ... â€œChief executiveâ€ redirects here. ... MÃ¥rten Mickos MÃ¥rten Gustaf Mickos (born November 6, 1962 in Espoo, Finland) is chief executive officer of MySQL AB. He has served as chief executive officer since January 2001. ...

The MySQL company used to sell another DBMS, MaxDB, which is from an unrelated codebase. MaxDB's sales and support have reverted back to SAP AG, where it originated^[4]. MaxDB is an ANSI SQL-92 (entry level) compliant relational database management system (RDBMS) from SAP AG, which was delivered also by MySQL AB from 2003 to 2007. ... SAP AG (ISIN: DE0007164600, FWB: SAP, NYSE: SAP) is the largest European software enterprise and the third largest in the world, with headquarters in Walldorf, Germany. ...

History

is the 143rd day of the year (144th in leap years) in the Gregorian calendar. ... Year 1995 (MCMXCV) was a common year starting on Sunday (link will display full 1995 Gregorian calendar). ... is the 8th day of the year in the Gregorian calendar. ... Year 1998 (MCMXCVIII) was a common year starting on Thursday (link will display full 1998 Gregorian calendar). ... A stored procedure is a subroutine available to applications accessing a relational database system. ... A partition is a division of a logical database or its constituting elements into distinct independent parts. ...

Programming languages

Libraries for accessing MySQL databases are available in all major programming languages with language-specific APIs. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++. Illustration of an application which may use libvorbisfile. ... A programming language is an artificial language that can be used to control the behavior of a machine, particularly a computer. ... API and Api redirect here. ... Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). ... This page is a candidate for speedy deletion. ... Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). ... Active Server Pages (ASP) is Microsofts server-side script engine for dynamically-generated web pages. ... ColdFusion is an application server and software development framework used for the development of computer software in general, and dynamic web sites in particular. ... The C Programming Language, 2nd edition, is a widely used reference on ANSI C. ANSI C is the standard published by the American National Standards Institute (ANSI) for the C programming language. ... C++ (pronounced see plus plus, IPA: ) is a general-purpose, programming language with high-level and low-level capabilities. ...

Uses

MySQL is popular for web applications and acts as the database component of the LAMP, MAMP, and WAMP platforms (Linux/Mac/Windows-Apache-MySQL-PHP/Perl/Python), and for open-source bug tracking tools like Bugzilla. Its popularity for use with web applications is closely tied to the popularity of PHP and Ruby on Rails, which is often combined with MySQL. PHP and MySQL are essential components for running popular content management systems such as WordPress and Drupal blogging platforms. Wikipedia runs on MediaWiki software, which is written in PHP and uses a MySQL database. In software engineering, a web application is an application delivered to users from a web server over a network such as the World Wide Web or an intranet. ... The acronym LAMP refers to a solution stack of software, usually free software / open-source software, used to run dynamic Web sites or servers. ... Bugzilla is a general-purpose bug-tracking tool originally developed and used by the Mozilla Foundation. ... For other uses, see PHP (disambiguation). ... Ruby on Rails is a free web application framework that aims to increase the speed and ease with which database-driven web sites can be created and offers skeleton code frameworks (scaffolding) from the outset. ... For other uses, see PHP (disambiguation). ... A Content Management System (CMS) is a software system used for content management. ... This article is about the self-hosted blog software. ... Drupal (IPA pronunciation: ) is a free and open source modular content management system (CMS) written in the programming language PHP. A CMS is a tool used by Web administrators to automatically track online visitors and prepare customized content for consumption, usually as HTML-based Web pages. ... Wikipedia (IPA: , or ( ) is a multilingual, web-based, free content encyclopedia project, operated by the Wikimedia Foundation, a non-profit organization. ... For the organization that manages Wikipedia and its sister projects, see Wikimedia Foundation. ...

Documentation and administration

Information on using MySQL can be found on the company's site, under their Documentation section. There are also many books written about MySQL.

To administer MySQL databases one can use the included command-line tool (commands: mysql and mysqladmin). Also downloadable from the MySQL site are GUI administration tools: MySQL Administrator and MySQL Query Browser. Both of the GUI tools are now included in one package called MySQL GUI Tools. A command line interface or CLI is a method of interacting with a computer by giving it lines of textual commands (that is, a sequence of characters) either from keyboard input or from a script. ... GUI redirects here. ...

In addition to the above mentioned tools developed by MySQL AB, there are several other commercial and non-commercial tools available. phpMyAdmin is a free software webbased administration interface implemented in PHP. phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL over the Internet. ... For other uses, see PHP (disambiguation). ...

Program specifications

Platforms

MySQL works on many different platforms — including AIX, BSDi, FreeBSD, HP-UX, i5/OS, GNU/Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OS/2 Warp, QNX, SGI IRIX, Solaris, SunOS, SCO OpenServer, SCO UnixWare, Tru64, Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP and Windows Vista. A port of MySQL to OpenVMS is also available.^[5] In computing, a platform describes some sort of framework, either in hardware or software, which allows software to run. ... AIX (Advanced Interactive eXecutive) is a proprietary operating system developed by IBM based on UNIX System V. Before the product was ever marketed, the acronym AIX originally stood for Advanced IBM UNIX. AIX has pioneered numerous network operating system enhancements, introducing new innovations later adopted by Unix-like operating systems... BSD/OS (originally called BSD/386 and commonly known as BSDi) was a commercial version of the BSD Unix operating system developed by Berkeley Software Design, Inc. ... FreeBSD is a Unix-like free operating system descended from AT&T UNIX via the Berkeley Software Distribution (BSD) branch through the 386BSD and 4. ... HP-UX (Hewlett Packard UniX) is Hewlett-Packards proprietary implementation of the Unix operating system, based on System V (initially System III). ... i5/OS is an operating system used on IBMs line of System i (previously called AS/400) computers. ... This article is about operating systems that use the Linux kernel. ... Mac OS X (pronounced ) is a line of graphical operating systems developed, marketed, and sold by Apple Inc. ... NetBSD is a freely redistributable, open source version of the Unix-like BSD computer operating system. ... NetWare is a network operating system developed by Novell, Inc. ... OpenBSD is a Unix-like computer operating system descended from Berkeley Software Distribution (BSD), a Unix derivative developed at the University of California, Berkeley. ... To meet Wikipedias quality standards, this article or section may require cleanup. ... QNX (pronounced either Q-N-X or Q-nix) is a commercial POSIX-compliant Unix-like real-time operating system, aimed primarily at the embedded systems market. ... Silicon Graphics, Inc. ... IRIX is a computer operating system developed by Silicon Graphics, Inc. ... Solaris is a computer operating system developed by Sun Microsystems. ... SunOS was the version of the UNIX operating system developed by Sun Microsystems for their workstations and server systems until the early 1990s. ... SCO OpenServer, previously SCO UNIX and SCO ODT, is a Unix-like computer operating system developed by Santa Cruz Operation (SCO) and now maintained by the SCO Group. ... UnixWare is a flavor of the Unix operating system. ... Tru64 is HPs (formerly Compaq; formerly DEC) 64-bit UNIX for the Alpha AXP platform. ... Windows 95 is a consumer-oriented graphical user interface-based operating system. ... Windows 98 (codenamed Memphis) is a graphical operating system released on June 25, 1998 by Microsoft and the successor to Windows 95. ... Windows Millennium Edition, or Windows Me (IPA pronunciation: [miË], [É›m iË]), is a hybrid 16-bit/32-bit graphical operating system released on September 14, 2000 by Microsoft. ... Windows NT (New Technology) is a family of operating systems produced by Microsoft, the first version of which was released in July 1993. ... Windows 2000 (also referred to as Win2K) is a preemptive, interruptible, graphical and business-oriented operating system designed to work with either uniprocessor or symmetric multi-processor computers. ... Windows XP is a line of operating systems developed by Microsoft for use on general-purpose computer systems, including home and business desktops, notebook computers, and media centers. ... Windows Vista is a line of graphical operating systems used on personal computers, including home and business desktops, notebook computers, Tablet PCs, and media centers. ... OpenVMS[1] (Open Virtual Memory System or just VMS) is the name of a high-end computer server operating system that runs on the VAX[2] and Alpha[3] family of computers developed by Digital Equipment Corporation of Maynard, Massachusetts (DIGITAL was then purchased by Compaq, and is now owned...

The latest production version

As of August 2007, MySQL offers MySQL 5.0 in two different variants: the MySQL Community Server and Enterprise Server. Both have a common code base and include the following features: 2007 is a common year starting on Monday of the Gregorian calendar. ... MySQL Enterprise is a subscription-based service produced by MySQL AB and targeted toward the commercial market. ...

The MySQL Enterprise Server is released once per month and the sources can be obtained either from MySQL's customer-only Enterprise site or from MySQL's BitKeeper repository, both under the GPL license. The MySQL Community Server is published on an unspecified schedule under the GPL and contains all bug fixes that were shipped with the last MySQL Enterprise Server release. Binaries are no longer provided by MySQL for every release of the Community Server.^[6]^[7] A stored procedure is a subroutine available to applications accessing a relational database system. ... A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. ... In database packages, the term cursor refers to a control structure for the successive traversal (and potential processing) of records in a result set as returned by a query. ... In database theory, a view is a virtual or logical table composed of the result set of a query. ... Distributed transaction is a set of two or more related transactions that has to be managed in a co-ordinated fashion. ... // In computer networking and databases, the two-phase-commit protocol is a distributed algorithm which lets all nodes in a distributed system agree to commit a transaction. ... InnoDB is a storage engine for MySQL, included as standard in all current binaries distributed by MySQL AB. Its main enhancement over other storage engines available for use with MySQL is ACID-compliant transaction support. ... A database engine is the underlying component that a Database Management System (DBMS) uses to create, retrieve, update and delete (CRUD) data from a database. ... MyISAM is the default storage engine for MySQL. It is based on the older ISAM code but has many useful extensions. ... InnoDB is a storage engine for MySQL, included as standard in all current binaries distributed by MySQL AB. Its main enhancement over other storage engines available for use with MySQL is ACID-compliant transaction support. ... Archive is a storage engine for the MySQL relational database management system. ... Secure Sockets Layer (SSL) and Transport Layer Security (TLS), its successor, are cryptographic protocols which provide secure communications on the Internet. ... This article is about the computer term. ... An SQL SELECT statement returns a result set of records from one or more tables. ... This article should be split into multiple articles accessible from a disambiguation page. ... MyISAM is the default storage engine for MySQL. It is based on the older ISAM code but has many useful extensions. ... The Unicode Standard, Version 5. ... Unicode reserves 1,114,112 (= 220 + 216) code points, and currently assigns characters to more than 96,000 of those code points. ... For other uses, see Acid (disambiguation). ... Berkeley DB (BDB) is a high-performance, embedded database library with bindings in C, C++, Java, Perl, Python, Ruby, Tcl, Smalltalk and many other programming languages. ... MySQL Cluster is a technology which added shared-nothing clustering capabilities to the MySQL database management system, starting with the production release of MySQL 4. ... BitKeeper is a software tool for revision control (configuration management, SCM, etc. ...

Future releases

Support for parallelization is also part of the roadmap for future versions.^[9] A partition is a division of a logical database or its constituting elements into distinct independent parts. ... Parallel computing is the simultaneous execution of the same task (split up and specially adapted) on multiple processors in order to obtain results faster. ...

Foreign key support for all storage engines will likely be released with MySQL 5.2 (although it has been present since version 3.23.44 for InnoDB). In the context of relational databases, a foreign key is a referential constraint between two tables[1]. The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. ... InnoDB is a storage engine for MySQL, included as standard in all current binaries distributed by MySQL AB. Its main enhancement over other storage engines available for use with MySQL is ACID-compliant transaction support. ...

A new storage engine is also in the works, called Falcon. A preview of Falcon is already available on Apache's website. Falcon is a new transactional storage engine for the MySQL relational database management system. ...

Distinguishing features

The following features are implemented by MySQL but not by some other RDBMSes: A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ...

MyISAM is the default storage engine for MySQL. It is based on the older ISAM code but has many useful extensions. ... Falcon is a new transactional storage engine for the MySQL relational database management system. ... The MySQL Federated storage engine for the MySQL relational database management system. ... Archive is a storage engine for the MySQL relational database management system. ... The comma-separated values (or CSV; also known as a comma-separated list or comma-separated variables) file format is a file type that stores tabular data. ... MySQL Cluster is a technology which added shared-nothing clustering capabilities to the MySQL database management system, starting with the production release of MySQL 4. ... InnoDB is a storage engine for MySQL, included as standard in all current binaries distributed by MySQL AB. Its main enhancement over other storage engines available for use with MySQL is ACID-compliant transaction support. ... solidDB is a relational database management system offered by Solid Information Technology (Solid). ... memcached is a general-purpose distributed memory caching system that was originally developed by Danga Interactive for LiveJournal, but is now used by many other sites. ... The inside/front of a Dell PowerEdge web server The term Web server can mean one of two things: A computer program that is responsible for accepting HTTP requests from clients, which are known as Web browsers, and serving them HTTP responses along with optional data contents, which usually are...

Server compilation type

There are 3 types of MySQL Server Compilations for Enterprise and Community users:

Beginning with MySQL 5.1, MySQL AB has stopped providing these different package variants. There will only be one MySQL server package, which includes a mysqld binary with all functionality and storage engines enabled. Instead of providing a separate debug package, a server binary with extended debugging information is also included in the standard package.^[10] MaxDB is an ANSI SQL-92 (entry level) compliant relational database management system (RDBMS) from SAP AG, which was delivered also by MySQL AB from 2003 to 2007. ... SAP AG (ISIN: DE0007164600, FWB: SAP, NYSE: SAP) is the largest European software enterprise and the third largest in the world, with headquarters in Walldorf, Germany. ...

Source code specifics

MySQL is written in C and C++. The SQL parser uses yacc and home-brewed lexer. A document describing some of the internal structures of the code and the coding guidelines is available from the MySQL web site.^[11] C is a general-purpose, block structured, procedural, imperative computer programming language developed in 1972 by Dennis Ritchie at the Bell Telephone Laboratories for use with the Unix operating system. ... C++ (pronounced see plus plus, IPA: ) is a general-purpose programming language with high-level and low-level capabilities. ... yacc is a computer program that serves as the standard parser generator on Unix systems. ... lex is a program that generates lexical analyzers (scanners or lexers). Lex is commonly used with the yacc parser generator. ...

Support

Via MySQL Enterprise MySQL AB offers support itself, including 24/7 30-minute response time, with the support team having direct access to the developers as necessary to handle problems. In addition it hosts forums and mailing lists and employees and other users are often available in several IRC channels providing assistance. 24/7 is an abbreviation which stands for 24 hours a day, 7 days a week, usually referring to the availability of a service. ...

Buyers of MySQL Enterprise enjoy access to binaries and software that is certified for their particular operating system, and access to monthly binary updates with the latest bug fixes. Several levels of Enterprise membership are available, with varying response times and features ranging from how to and emergency support through server performance tuning and system architecture advice. The MySQL Network Monitoring and Advisory Service monitoring tool for database servers is available only to MySQL Enterprise customers.

Licensing

MySQL AB makes MySQL Server available as free software under the GNU General Public License (GPL), but they also offer the MySQL Enterprise subscription offering for business users and dual-license it under traditional proprietary licensing arrangements for cases where the intended use is incompatible with the GPL. MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... Free software is software that can be used, studied, and modified without restriction, and which can be copied and redistributed in modified or unmodified form either without restriction, or with restrictions only to ensure that further recipients can also do these things. ... GPL redirects here. ... MySQL Enterprise is a subscription-based service produced by MySQL AB and targeted toward the commercial market. ... This page meets Wikipedias criteria for speedy deletion. ... Proprietary software is software with restrictions on copying and modifying as enforced by the proprietor. ...

Both the MySQL server software itself and the client libraries are distributed under a dual-licensing format. Users may choose the GNU General Public License^[12], which MySQL has extended with a FLOSS License Exception. It allows Software licensed under other OSI-compliant Open Source licenses, which are not compatible to the GPL, to link against the MySQL client libraries.^[13] GPL redirects here. ... From the early 90s onward, alternative terms for free software have come into common use, with much debate in the free software community. ... The Open Source Initiative is an organization dedicated to promoting open source software. ...

Customers that do not wish to be bound to the terms of the GPL may choose to purchase a proprietary license.^[14] Proprietary software is software with restrictions on copying and modifying as enforced by the proprietor. ...

Like many open-source programs, the name "MySQL" is trademarked and may only be used with the trademark holder's permission. This is a list of free/open source packages whose names are covered by registered trademarks. ... â€œ(TM)â€ redirects here. ...

Some users have independently continued to develop earlier versions of the client libraries, which was distributed under the less-restrictive Lesser General Public License.^[15] GNU logo The GNU Lesser General Public License (formerly the GNU Library General Public License) is an FSF approved Free Software license designed as a compromise between the GNU General Public License and simple permissive licenses such as the BSD license and the MIT License. ...

Issues

There has been some controversy regarding the distribution of GPLed MySQL library files with other open source applications. The biggest controversy arose with PHP, which has a license incompatible with the GPL. This was later resolved when MySQL created a license exception that explicitly allows the inclusion of the MySQL client library in open source projects that are licensed under a number of OSI-compliant Open Source licenses, including the PHP License.^[16] For other uses, see PHP (disambiguation). ... For the PHP Cold War history project, see Parallel History Project. ...

In September 2005, MySQL AB and SCO forged a partnership for "joint certification, marketing, sales, training and business development work for a commercial version of the database for SCO's new OpenServer 6 version of Unix". SCO raised controversy beginning in 2003 with a number of high-profile patent lawsuits related to the Linux Operating System. Various MySQL employees expressed that the company was committed to serving its end users, regardless of their operating system choice, that the company would leave it to the courts to resolve the SCO licensing controversy, and that other common open source databases have also been ported to, and support, SCO OpenServer. The SCO Group, Inc. ... The SCO-Linux controversies are a series of legal and public disputes between the software company SCO Group (SCO) and various Linux vendors and users. ... For other uses, see Patent (disambiguation). ... Civil action redirects here. ... This article is about operating systems that use the Linux kernel. ... An operating system (OS) is the software that manages the sharing of the resources of a computer and provides programmers with an interface used to access those resources. ... SCO OpenServer, previously SCO UNIX and SCO ODT, is a Unix-like computer operating system developed by Santa Cruz Operation (SCO) and now maintained by the SCO Group. ...

In October 2005, Oracle Corporation acquired Innobase OY, the Finnish company that developed the InnoDB storage engine that allows MySQL to provide such functionality as transactions and foreign keys. A press release^[17] by Oracle that was issued after the acquisition mentioned that the contracts that make the company's software available to MySQL AB come up for renewal (and presumably renegotiation) some time in 2006. During the MySQL Users Conference in April 2006, MySQL issued a press release which confirmed that MySQL and Innobase OY agreed to a multi-year extension of their licensing agreement.^[18] Oracle Corporation (NASDAQ: ORCL) is one of the major companies developing database management systems (DBMS), tools for database development, middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software. ... InnoDB is a storage engine for MySQL, included as standard in all current binaries distributed by MySQL AB. Its main enhancement over other storage engines available for use with MySQL is ACID-compliant transaction support. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ...

In February 2006, Oracle Corporation acquired Sleepycat Software,^[19] makers of the Berkeley DB, a database engine onto which another MySQL storage engine was built. Oracle Corporation (NASDAQ: ORCL) is one of the major companies developing database management systems (DBMS), tools for database development, middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software. ... Sleepycat Software, Inc. ... Berkeley DB (BDB) is a high-performance, embedded database library with bindings in C, C++, Java, Perl, Python, Ruby, Tcl, Smalltalk and many other programming languages. ...

Criticism

Early versions of MySQL lacked many standard relational database management system (RDBMS) features, usually with the goal of trading guaranteed accuracy for speed. Many (but not yet all) such criticisms have been remedied in later versions of the software, including transactions and relational integrity constraints — features necessary to support "ACID properties" for relational databases, which allow the DBMS to ensure that client applications cannot interfere with one another or insert inconsistent values.^[20] A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ... A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions. ... For other uses, see Acid (disambiguation). ...

Earlier versions of the MySQL manual included claims that certain missing ACID features were useless or even harmful, and that users were better off without them. One section, entitled "Reasons NOT to use Foreign Keys constraints" (sic), advised users that relational-integrity checking was difficult to use and complicated a database application, and that its only useful purpose was to allow client software to diagram the relationships between database tables.^[21] Another section claimed that a DBMS lacking transactions can provide data-integrity assurances as reliable as those provided by a DBMS that supports transactions — thus conflating the issue of transactional integrity with that of saving data when the database server loses power.^[22]

Another criticism is MySQL's divergence from the SQL standard on the subject of treatment of NULL values and default values. Its handling of dates allows storing a date with a day beyond the last day of a month with fewer than 31 days, and arithmetic operations are vulnerable to either integer overflow or floating point truncation.^[23] Since version 5 of the server, the treatment of illegal values varies according to use of the "SQL Mode" set in the server, which is by default set to the unusually tolerant state that critics dislike.^[24]

When the beta version of MySQL 5.0 was released in March 2005, David Axmark, a co-founder of MySQL, said that "People have been criticizing MySQL since we started for not having stored procedures, triggers and views," and "We're fixing 10 years of criticism in one release."^[25] MySQL 5.0's 13 October build 5.0.15 was released for production use on 24 October 2005, after more than two million downloads in the 5.0 beta cycle. is the 286th day of the year (287th in leap years) in the Gregorian calendar. ... is the 297th day of the year (298th in leap years) in the Gregorian calendar. ... Year 2005 (MMV) was a common year starting on Saturday (link displays full calendar) of the Gregorian calendar. ...

MySQL Application of the Year winners

2006 YouTube is a popular video sharing website where users can upload, view and share video clips. ... Ampd Mobile was a mobile phone service launched in the United States in late 2005. ... Adobe Systems (pronounced a-DOE-bee IPA: ) (NASDAQ: ADBE) (LSE: ABS) is an American computer software company headquartered in San Jose, California, USA. Adobe was founded in December 1982[1] by John Warnock and Charles Geschke, who established the company after leaving Xerox PARC in order to develop and sell...

2005 This article is about the telecommunications corporation. ... Flickr is a photo sharing website and web services suite, and an online community platform, which is generally considered an early example of a Web 2. ...

CNET Networks, Inc. ... Friendster is an Internet social network service. ... Wikipedia (IPA: , or ( ) is a multilingual, web-based, free content encyclopedia project, operated by the Wikimedia Foundation, a non-profit organization. ...

Pronunciation

"MySQL"'s official pronunciation of the name is "My Ess Que Ell",^[27] pronounced as /maɪ ɛs kjuː ɛl/, not "My sequel" /maɪ siːkwəl/. This adheres to the official ANSI pronunciation; SEQUEL was an earlier IBM database language, a predecessor to the SQL language.^[28] However, the company does not take issue with the pronunciation "My sequel" or other local variations.

The "My" portion of the name may come from the name of Widenius's child, spelled "My" but pronounced in Swedish as mü /my/ (or approximately in English, "me"). However, MySQL's own developers are unsure if this is the case or if it is in fact a simple possessive.^[29]

See also

Image File history File links Free_Software_Portal_Logo. ... Image File history File links Wikibooks-logo-en. ...

Clients

There are very few or no other articles that link to this one. ... MySQL Workbench is a visual database design tool that gives you system that integrates database design, modeling, creation and maintenance into a single, seamless environment for the MySQL database system. ... SQLPro is a visual database management and development tool for multiple databases. ... Navicat is a MySQL management and development software from PremiumSoft, known for its combination of power and ease of use. ... Navicat is a MySQL management and development software from PremiumSoft, known for its combination of power and ease of use. ... SQLyog is a Graphical User Interface (GUI) for the popular Relational Database Management System (RDBMS) MySQL. The software is created by the software development company Webyog, based in Bangalore. ...

References

MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era in the 21st century. ... is the 41st day of the year in the Gregorian calendar. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era in the 21st century. ... is the 41st day of the year in the Gregorian calendar. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ... Year 2007 (MMVII) is the current year, a common year starting on Monday of the Gregorian calendar and the AD/CE era in the 21st century. ... is the 41st day of the year in the Gregorian calendar. ... MySQL AB (founded 1995) is dual headquartered in Uppsala, Sweden and Cupertino, California, USA. The company is the creator and owner of MySQL, a relational database management system. ...

External links

Documentation

Articles and guides

Categories: Database management systems | Open source database management systems | FSF/UNESCO A database management system (DBMS) is computer software designed for the purpose of managing databases. ... A data model is not just a way of structuring data: it also defines a set of operations that can be performed on the data. ... Database normalization is a design technique for structuring relational database tables. ... Database tables/indexes are typically stored in memory or on hard disk in one of many forms, ordered/unordered Flat files, ISAM, Heaps, Hash buckets or B+ Trees. ... According to Elmasri and Navathe (2004, p. ... An example of a database that has not enforced referential integrity. ... Relational algebra, an offshoot of first-order logic, is a set of relations closed under operators. ... The relational calculus refers to the two calculi, the tuple calculus and the domain calculus, that are part of the relational model for databases and that provide a declarative way to specify database queries. ... A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ... The relational model for database management is a database model based on predicate logic and set theory. ... In computer science, transaction processing is information processing that is divided into individual, indivisible operations, called Each transaction must succeed or fail as a complete unit; it cannot remain in an intermediate state. ... This article is about computing. ... For other uses, see Acid (disambiguation). ... The Greek lowercase omega (Ï‰) character is historically used by academics to represent Null in relational databases. ... In the relational model a candidate key of a relation variable (relvar) is a set of attributes of that relvar such that (1) at all times it holds in the relation assigned to that variable that there are no two distinct tuples with the same values for these attributes and... In the context of relational databases, a foreign key is a referential constraint between two tables[1]. The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. ... In database design, a primary key is a value that can be used to identify a unique row in a table. ... A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. ... A surrogate key is a unique primary key generated by the relational database management system that is not derived from any data in the database and whose only significance is to act as the primary key. ... A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. ... In database theory, a view is a virtual or logical table composed of the result set of a query. ... In relational databases, SQL databases, and flat file databases, a table is a set of data elements (values) that is organized using a model of horizontal rows and vertical columns. ... In database packages, the term cursor refers to a control structure for the successive traversal (and potential processing) of records in a result set as returned by a query. ... In in the field of databases in computer science, a transaction log (also database log or binary log) is a history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures. ... A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions. ... A database index is a data structure that improves the speed of operations in a table. ... A stored procedure is a subroutine available to applications accessing a relational database system. ... A partition is a division of a logical database or its constituting elements into distinct independent parts. ... SQL (IPA: or ) is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ... An SQL SELECT statement returns a result set of records from one or more tables. ... A SQL INSERT statement adds one or more records to a table in a relational database. ... An UPDATE statement in SQL changes data in one or more records in a relational database management system. ... Wikipedia does not have an article with this exact name. ... An SQL DELETE statement removes one or more records from a table. ... A JOIN clause in SQL combines records from two tables in a relational database and results in a new (temporary) table, also called a joined table. Structured Query Language (SQL:2003) specifies two types of joins: inner and outer. ... In SQL the UNION operator combines the results of two SQL queries into a single table of all matching rows. ... A CREATE statement in SQL creates an object inside of a relational database management system (RDBMS). ... A DROP statement in SQL removes an object from a relational database management system (RDBMS). ... It has been suggested that this article or section be merged into Database transaction. ... A COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users. ... In database technologies, a rollback is an operation which returns the database to some previous state. ... The Truncate statement removes all the data from a table. ... An ALTER statement in SQL changes the properties of an object inside of a relational database management system (RDBMS). ... A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ... A simple diagram depicting conversion of a CSV-format flat file database table into a relational database table. ... A deductive database system is a database system which can make deductions (ie: infer additional rules or facts) based on rules and facts stored in the (deductive) database. ... A dimensional database is one which, rather than representing data in multiple relations (as a relational database does), represents key data entities as different dimensions. ... In a hierarchical data model, data are organized into a tree-like structure. ... The network model is a database model conceived as a flexible way of representing objects and their relationships. ... In an object oriented database, information is represented in the form of objects as used in Object-Oriented Programming. ... An object-relational database (ORD) or object-relational database management system (ORDBMS) is a relational database management system that allows developers to integrate the database with their own custom data types and methods. ... A temporal database is a database management system with built-in time aspects, e. ... An XML database is a data persistence software system that allows data to be imported, accessed and exported in the XML format. ... In computer science -- more specifically, in the field of databases -- concurrency control is a method used to ensure that database transactions are executed in a safe manner (i. ... Query languages are computer languages used to make queries into databases and information systems. ... The query optimizer is a component of database management system that is used to analyzes queries submitted to database server for execution, and then determines the optimal way to execute the query. ... A query plan (or query execution plan) is an set of steps used to access information in a SQL relational database management system. ... In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). ... JDBC is an API for the Java programming language that defines how a client may access a database. ... The following is a list of object-oriented database management systems. ... This article or section is not written in the formal tone expected of an encyclopedia article. ... See DBMS for a shorter list of â€œtypicalâ€, representative database management systems. ... The following tables compare general and technical information for a number of relational database management systems. ...

Contents

History GA_googleFillSlot("encyclopedia_square");