MySQL is one of the most popular databases in the world, and no one agrees on how to pronounce it.

Either “My Sequel” or “My S-Q-L” are okay, so don’t let anyone tell you otherwise.

A database is just a fancy spreadsheet that can hold tons of information and interact with programs. MySQL is one of the most popular because it’s found pretty much anywhere you can write a program, and it’s free.

In something like Excel or Microsoft Access you can poke and prod and drag values around, but databases like MySQL don’t really have a way to see them without using another program. You get to type something like this:

SELECT name FROM cocktails WHERE color = 'red'

Which, as you can probably tell, gets us all the cocktails that are red. This incredibly droll method of talking to a database is called the Structured Query Language, and it’s the SQL part of MySQL.

Databases are a powerful part of any dynamic web site, and MySQL is a widely-used and widely-known option.

There are a ton of database solutions out there, and everyone is always arguing about what is best. One particularly vocal group at the moment is the NoSQL movement, which is against RDBMS’s (Relational database management systems – say that five times fast). Other people might push PostgreSQL or Microsoft’s SQL Server.

Many large tech companies use multiple databases for different things. Facebook and Twitter use both MySQL and a NoSQL database called Cassandra, among I’m sure many others.

A big benefit of MySQL and many other RDBMSes is something called ACID compliance. You can read more about it here, but the basic idea is that it’s a very reliable system in terms of data integrity. If you accidentally lose a couple tweets, no big deal, but if your database forgets to deposit $50,000 into your bank account someone’s in trouble.

Cocktail Party Fact

It isn’t called “MySQL” because it’s yours – it’s actually named after the daughter of the main developer, My, which is a common Finnish nickname!

Leave a Reply to sareg0

Your email address will not be published.



  1. DMC5 Replied

    I couldn’t refrain from commenting. Exceptionally well written!

  2. Ludivina Franzetti Replied

    I ran into this page accidentally, surprisingly, this is a great website. The site owner has done a great job writing/collecting articles to post, the info here is really and helpful when i do research. You just secured yourself a guarenteed reader.

  3. Joette Elbogen Replied

    “I have been browsing online more than 3 hours nowadays, yet I by no means found any fascinating article like yours. It is lovely price enough for me. In my opinion, if all website owners and bloggers made good content as you probably did, the net might be much more useful than ever before.”

  4. furtdsolinopv Replied

    I together with my guys have already been reading the good tricks on your web site and then then I got a horrible feeling I had not expressed respect to the website owner for those tips. The guys had been excited to read through them and now have definitely been making the most of these things. We appreciate you really being really considerate and for picking out some fantastic guides most people are really needing to learn about. Our sincere regret for not saying thanks to you sooner.

  5. furtdsolinopv Replied

    Hey there just wanted to give you a quick heads up and let you know a few of the pictures aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different internet browsers and both show the same outcome.

  6. furtdso linopv Replied

    I do like the manner in which you have presented this particular challenge and it really does present me personally some fodder for thought. Nonetheless, because of everything that I have observed, I just simply hope as the remarks stack on that men and women remain on point and in no way start upon a soap box regarding the news du jour. Yet, thank you for this superb piece and though I can not concur with this in totality, I respect the viewpoint.

  7. codemeshon Replied

    I’m still a bit confused.. can someone simplify it even more for me… databases and how it relates to MySQL.. I’m trying to visualize what that looks like but struggling.

    • pizzacrusta Replied

      I guess what made it easier for me is to think of MySQL as an application and a place to store data (database). Within the application, SQL (structured query language) is used to communicate to the database. The application uses it to retrieve, input, add, delete etc… data.

      (Someone please correct me if I’m wrong or if you would like to add on).

  8. artaffects Replied

    OK. So what exactly is the difference between all these SQLs, No-SQLs, Pre-SQLs, and such? Not trying to be a smart @ss. Just want to know. :) 

    • sareg0 Replied

      Hey artaffects,
      That’s a good question.
      SQL is the query language by which one goes about ‘querying’ a database.
      NoSQL is a type of storage, but just doesn’t have sql as the query language :)

Want more articles like this?

Sign up to get the most recent tech news, tips and career advice.