zpostcode
MySQL
Apr 21, 2026 6:47 AM

  MySQL, open-source relational database management software, owned by the computer software company Oracle, that allows users to interact with large amounts of data across multiple databases. MySQL is one of the most popular database management programs used worldwide.

  Though SQL is sometimes referred to as “S-Q-L,” it is more often called “sequel,” in acknowledgment of its historical roots as “Structured English Query Language.”

  A database allows users to store and organize large amounts of data in a computer. Data is typically stored in a relational database format, wherein it is arranged into rows and columns that form groups of tables. This helps to improve the efficiency of processing and querying data. Computer scientists can use a programming language known as Structured Query Language (SQL) to manage, parse, and analyze the data stored on SQL Servers, which act as relational database management systems. Users can instruct the SQL Server to query or identify data. SQL can also be used to insert data, modify and delete data, and even create, modify, and delete entire tables. Though SQL is sometimes referred to as “S-Q-L,” it more often is called “sequel,” in acknowledgment of its historical roots as “Structured English Query Language.”

  SQL was invented in the 1970s by IBM researchers Raymond Boyce and Donald Chamberlin, though they called it “SEQUEL” at the time. In 1986 the American National Standards Institute designated SQL as the standard for interacting with relational databases. In 1995 MySQL was developed by the Swedish company MySQL AB (acquired by Oracle in 2010) to provide a user-friendly relational database management software. In 2000 MySQL was released with a GNU General Public License, making it open source and free to download.

  MySQL software provides users with a graphical user interface that allows them to make requests on database servers in order to receive output values. It is generally considered to be easier to extract values using MySQL than raw SQL code. Because MySQL is written in C and C++ programming languages, MySQL is compatible with most operating systems, including Windows, macOS, and Linux. MySQL also supports connectivity through application programming interfaces, which can link data to various programs, libraries, and administrative tools.

  MySQL has surpassed the user base of competitors such as Microsoft SQL Server, PostgreSQL, and MongoDB. Multiple websites that use a database management system use MySQL, including Google, Facebook, and Adobe. More than half of all information technology companies use MySQL to manage their databases as well. Web developers often deploy MySQL as part of a software set known as LAMP, so named because it includes Linux, Apache Web server, MySQL, and PHP (a scripting language), all of which are open-source software. The LAMP stack is frequently used to create high-performance Web applications.

  Get a Britannica Premium subscription and gain access to exclusive content. Subscribe Now

Comments
Welcome to zpostcode comments! Please keep conversations courteous and on-topic. To fosterproductive and respectful conversations, you may see comments from our Community Managers.
Sign up to post
Sort by
Show More Comments
Recommend >
Tamara de Lempicka
  Tamara de Lempicka (born May 16, 1898?, Warsaw, Poland?—died March 18, 1980, Cuernavaca, Mexico) was a 20th-century artist who created a unique painting style, often called “stylized cubism,” which appears to combine the monumentality of 16th-century Mannerism, the mechanical feel of Italian Futurism, and the exaggeration of contemporary fashion magazines. De Lempicka is perhaps best known for depicting the ideal...
Battle of Balaklava
  Battle of Balaklava, also spelled Balaclava, (Oct. 25 [Oct. 13, Old Style], 1854), indecisive military engagement of the Crimean War, best known as the inspiration of the English poet Alfred, Lord Tennyson’s “Charge of the Light Brigade.” In this battle, the Russians failed to capture Balaklava, the Black Sea supply port of the British, French, and Turkish allied forces in...
Valerie Adams
  Valerie Adams (born October 6, 1984, Rotorua, New Zealand) is a retired shot-putter and Olympian who was virtually undefeated in the major international competitions in her sport between 2006 and 2014. She competed in five Olympic Games, earning gold medals in two. Adams also earned gold medals in three Commonwealth Games and several IAAF (International Association of Athletics Federations) World...
Battle of Carthage
     How Hannibal's conquests led to the fall of CarthageOverview of the rise and fall of Carthage, with a detailed discussion of Hannibal's victories against Rome, including the Battle of Cannae, and his later defeat at the Battle of Zama.(more)See all videos for this articleThe Battle of Carthage in 146 bce ended generations of war between the Phoenician-founded city and...
Information Recommendation
Wu Minxia
  Wu Minxia (born November 10, 1985, Shanghai, China) is the most-decorated female athlete in the history of diving and became the most-decorated Chinese athlete in Olympic history at the 2016 Games in Rio de Janeiro. There she won her seventh medal overall, more than any other Chinese athlete. One of the medals Wu won was a gold medal for the...
Stephanie Wilson
  Stephanie Wilson (born September 27, 1966, Boston, Massachusetts, U.S.) is an American astronaut who has made three spaceflights to the International Space Station (ISS) on the space shuttle Discovery and is part of the Artemis team of astronauts who are to fly to the Moon in the mid-2020s. She was the second Black woman in space, after Mae Jemison.   Wilson...
Sophie Pascoe
  Sophie Pascoe (born January 8, 1993, Christchurch, New Zealand) is a New Zealand swimmer and the country’s most successful Paralympian, having won a total of 19 Paralympic medals. She has competed in four Paralympic Games, a major international sports competition for athletes with disabilities comparable to the Olympic Games. For Paralympic athletes there are 10 eligible impairment types—including limb deficiency,...
Yorgos Lanthimos
  Yorgos Lanthimos (born September 23, 1973, Athens, Greece) is a Greek director and screenwriter known for his surreal films that combine absurd scenarios, striking set designs, and stories of penetrating psychological insight. Lanthimos learned his trade directing television commercials and music videos in Greece before turning to feature films. His movies include The Favourite (2018) and Poor Things (2023), both...
Battle of Jumonville Glen
  Battle of Jumonville Glen, opening battle of the French and Indian War, fought on May 28, 1754, also noteworthy as the combat action for George Washington. Imperial ambitions brought England and France into conflict in the Ohio River Valley, forming a theater in the global Seven Years’ War, of which, it is believed, the Battle of Jumonville Glen was the...
Battle of Gibraltar
  Battle of Gibraltar, naval battle fought on April 25, 1607, between ships of the Spanish Empire and the Dutch United Provinces. After their loss at the Battle of Ostend, the Dutch United Provinces intensified their maritime campaign against Spain. This culminated in the breathtakingly bold raid on the Spanish fleet in harbor at Gibraltar, one of the most celebrated Dutch...
Battle of Kasserine Pass
  Battle of Kasserine Pass, the first large-scale encounter in World War II between Italian and German land forces and the U.S. army, fought February 14–24, 1943. The Axis offensive along the Kasserine Pass, in a gap in the Atlas Mountains of west-central Tunisia, resulted in a humiliating setback for the Americans, but they recovered quickly and prevented the Axis forces...
Battle of Corregidor
  Battle of Corregidor, the successful recapture by U.S. troops on February 16–March 2, 1945, during World War II, of Corregidor Island. Located at the entrance of Manila Bay in the Philippines, Corregidor had been called the “Gibraltar of the East.” The fort had been surrendered to invading Japanese forces on May 6, 1942, marking the fall of the Philippines to...