MySQL is a database management system that uses the SQL language to define, update and query the database. SQL, or Structured Query Language, is a database language that’s used to pull, edit, and create information in a database.
Think of a database as a one big filing cabinet where information is stored, such as content, images, records, etc., – but without all the paper. In order to add, retrieve, and process data stored in a computer database, you need a database management system.
Table of Contents
Why Use MySQL?
If your website requires MySQL, you’ll have no problem finding a web host since MySQL interfaces with PHP – over 70% of the world’s servers run PHP. Some hosting packages allow you to create additional MySQL databases on your account or even unlimited MySQL databases.
Having more than one MySQL database can be important if you want to create multiple websites with polished, interactive web pages. Your website(s) will generate more data, therefore you will need more room for it to be stored and organized. Storage consumed by MySQL databases shares your disc space quota with the rest of your web files, images, videos, audio, and even emails.
There are many reasons why MySQL is so popular:
- It’s open source – Open source programs allow communities to access the code under the hood, given them an opportunity to crowd source troubleshooting, support, documentation, customization, and development.
- It’s easy to use – MySQL is easy to install, relatively fast, and loaded with features, including visual web tools such as phpMyAdmin.
- It’s widely available – MySQL can be installed on many different platforms including Windows, Linux, and Mac OS.
- It’s widely used – Joomla, WordPress, and Drupal all use MySQL, as do many organizations such as Nokia, Google, Facebook, and YouTube.
- It works well with PHP – MySQL works with PHP (Personal Home Page) to make dynamic pages in your Web site. (*PHP has a native database support from MySQL.).
- It’s versatile. – MySQL also works with C, C++ and C#, D, Java, Ruby, and Objective C.
- It’s free – MySQL Is free to download and use!
MySQL is what’s called a relational database management system (RDBMS). A relational database is a system that organizes many pieces information into neat, orderly structures while keeping track of how all those pieces of information are related to each other.
The ability to define relationships is what differentiates relational databases from other types of databases. SQL is the language used for querying and managing data in a relational database system.
MySQL vs. Other Relational Databases
Not all relational databases are created equal. Each database has its own unique method of connecting and transporting information, but what sets MySQL apart from other relational databases is MySQL having multiple storage engines – this allows you to choose which is most effective for your application.
The following table, provided by udemy, includes information about the three popular relational databases, Oracle, MySQL, and SQL Server, and how they compare:
|Interface||GUI, SQL||SQL||GUI, SQL, Various|
|Language support||Many, including C, C#, C++, Java, Ruby, and Objective C||Many, including C, C#, C++, D, Java, Ruby, and Objective C||Java, Ruby, Python, VB, .Net, and PHP|
|Operating System||Windows, Linux, Solaris, HP-UX, OS X, z/OS, AIX||Windows, Linux, OS X, FreeBSD, Solaris||Windows|
How To Get Started With MySQL
If you’re new to MySQL, these resources will familiarize you with all the basics, including links to useful PHP code snippets and examples.
- Get Started with MySQL – Need help installing MySQL on your platform of choice? You’ll find links to tutorials on how to install MySQL on Windows, Mac OS X, and Linux.
- A Basic MySQL Tutorial – This tutorial provides the simplest introduction to MySQL with easy-to-follow instructions and screenshots.
- Everything You Need to Get Started With MySQL – Here you’ll find a useful introduction to the world of relational databases allowing you to maximize your data’s potential.
- MySQL Database Tutorial – 1 – Introduction to Databases (video) – If you want to learn more about how a database works and to become familiar with the some of the jargon you’ll come across, this tutorial serves as your Introduction to Databases, 101.
- Virtual Workshops: MySQL Databases and the SQL Language: These workshops offer simple, if fairly comprehensive, introduction to MySQL and to SQL.
- MySQL 5.0 Reference Manual – Chapter 3 Tutorial: This chapter provides a tutorial introduction to MySQL by showing how to use the MySQL client program to create and use a simple database.
- MySQL Tutorial: This website provides you with a complete MySQL tutorial presented in an easy-to-follow manner. Each tutorial has practical examples with SQL script and screenshots available.
- Free Webmaster Help: PHP/MySQL Tutorial: In this tutorial, you’ll learn how to use PHP and the MySQL database to store information on the web and include it into your website.
- Tutorials Point: MySQL Tutorial: This tutorial will give you quick start with MySQL and make you comfortable with MySQL programming.
SQL Learning Resources
Learning SQL will give you another tool in your toolbox to help make your website better and faster. If you know SQL and understand its fundamental concepts, you’ll be in better control of your data. Check out the resources below to learn the basic elements of SQL and the relational data model.
- SQL for Beginners. Learn basics of SQL in 1 Hour (video) – You can watch this video to learn the basics of SQL and relational theory.
- Let’s Learn SQL Part 1 – Basic Select Statements – This video covers all the basics of SQL, just to get your feet wet.
- Structured Query Language (PDF) – With over 50 pages of useful information, this tutorial (available for download) is one of the best handbooks out there for free.
- What is SQL? – SQLCourse.com offers an interactive online SQL training course that covers just about everything you’ll need to learn SQL, including how to insert a table and updating records.
- Writing SQL Queries: Let’s Start with the Basics – Here you’ll learn about the most basic elements of a SQL SELECT statement used for common database querying tasks.
Technical Support Resources
Help is out there if you need it. Below are a list of support resources to ensure your experience with MySQL is a good one with links to forums and message boards which offer help to a varied skill level.
- MySQL – MySQL Technical Support Services provide direct access to MySQL Support engineers who can assist users in the development, deployment, and management of MySQL applications.
- Learning MySQL – This densely packed tutorial (available for download) includes detailed instructions to help you set up and design an effective database with MySQL.
- MySQL Forums – Forums are a great place to find answers to commonly asked questions as well as suggestions on how to improve your experience with MySQL.