zpostcode
MySQL
Apr 4, 2026 1:17 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 >
How debt collection affects your credit score—and steps you can take
     If you’re facing debt collection, then you may be concerned about how unpaid debts can affect your credit score. Debt collection is usually detrimental, but the good news is that the negative effects don’t last forever. You have options—both during and after the debt collection process—to ensure that your credit score bounces back.   Your credit score is important because...
Money market account vs. CD: Which one should you choose?
     The record-low interest rates common in the 2010s may have made you hesitant to put your money into a money market account or especially a certificate of deposit (CD). But since the Federal Reserve has hiked interest rates, the yields offered on these accounts have risen significantly. That’s prompted savers to once again consider these traditional savings accounts—and perhaps...
What is a living will, and why do you need one?
     In the realm of health care planning, few documents hold as much weight and significance as a living will. This legal document is a type of advance directive that allows you to specify your preferences for medical treatment in the event that you become incapacitated and unable to communicate your wishes.   Unlike a traditional will, which addresses the distribution...
3 liquidity ratios: Assessing short-term financial viability
     Measuring a company’s liquidity ratio is like checking a car’s fuel or electricity gauge.   Even a zippy Lamborghini or top-of-the-line Tesla won’t get you to your destination if it runs short of juice. Likewise, if a company runs out of cash—or assets to be converted to cash—to pay its short-term liabilities, well, that’s potentially the end of the line...
Information Recommendation
Getting maximum value from downsizing: Declutter for fun and profit
     If yours is like many American households, you may have more things hiding in your cupboards, closets, or basement than you know what to do with. If you’re staying put, the clutter may be a mere annoyance. But if you plan on moving, that’s when things get real: You have to figure out what to do with all that...
What everyone should know about debt collection
     If you’re wondering about debt collection and how it works, then you may have gotten yourself into a financial pickle. Life happens—and sometimes your debt obligations exceed your repayment capacity. Understanding the nuances of debt collection is important for every borrower, even if you always pay on time.   And if you find yourself facing debt collection? Going through the...
10 ways the Fair Debt Collection Practices Act protects you
     One of the most important features of the U.S. debt collection process is that debtors—and creditors, too—have well-defined rights. The Fair Debt Collection Practices Act (FDCPA) was first signed into law way back in 1977 (and most recently updated in 2010), precisely because Congress found “abundant evidence of the use of abusive, deceptive, and unfair debt collection practices by...
Dividend aristocrats and kings: Investing for the long haul
     As an investor, you may be looking for stocks and exchange-traded funds (ETFs) that can provide you with a little extra value over the long term.   If you’re planning to hold shares of a company for the long haul, you might want to consider looking at the S&P 500 dividend aristocrats and dividend kings. These are stocks with long...
How to invest in art and collectibles: From pastime to portfolio
     Investing in art and other collectibles offers some features that traditional stock and bond investing simply can’t: physical appeal and enjoyment. You can admire a painting on your living room wall, play a violin, and wear a watch.   Collectible investments are considered an alternative asset class; their value often is not correlated to the stock and bond market. But...
Tax schedules and forms related to Form 1040, U.S. Individual Tax Income Tax Return
     It’s time to file taxes again this year. You might prepare your taxes yourself or have a tax preparer help you. But as your return gets more complex—maybe thanks to your investments, or your home business, or your kids’ college expenses—more schedules and forms will be needed to help report your income and deductions to the IRS.   The individual...
Money market account vs. checking account: Which is best?
     A checking account is a financial workhorse. From paying bills, to shopping, to getting quick cash, a checking account can do it all—except when it comes to paying you a decent interest rate on your balance.   The yields on most checking accounts are minimal at best, and many pay nothing at all. But there is an alternative. A money...
6 key strategies for a debt management program
     Are you looking to design a debt management program? Perhaps one of your goals is to avoid the debt collection process.   A debt management program that accomplishes your money objectives may involve some combination of financial planning, debt restructuring, and getting hardship assistance. You can also consider the extreme option for avoiding debt collection: declaring bankruptcy.   Here are six...