MySQL is a database. A database is a data storage feature. It can be used to store, sort, arrange, and display information. MySQL is a functional feature on it's own. For our tutorials, we will be using PHP commands to use the functions of a MySQL database.
phpMyAdmin is a graphical interface program that allows you to use the functions of a MySQL database. Some hosts may have this program available.
MySQL is a data storage area. In this storage area, there are small sections called TABLES. Very similar to a normal HTML table, the MySQL tables consist of rows, columns, and cells.
You can learn about MySQL from their source website here... http://www.mysql.com
You can learn about phpMyAdmin from their source website here... http://www.phpmyadmin.net/home_page/.
Other tutorials will go through the process of installing and operating the MySQL database. We will assume you have an online host that supports and offers a MySQL database for your site.
Table of Contents
Learn More About MySQL
Learn about the php command "include" and how it's used to connect to a MySQL database.
Learn about all the various data types that can be used in and are supported by MySQL.
Learn about how to use SQL joins in MySQL.
LIKE and NOT LIKE
Learn about how to use LIKE and NOT LIKE SQL clauses in MySQL.
Learn about column modifiers in MySQL.
Learn about what MySQL's INSERT SQL command is and why you'd use it.
Learn about how to use the WHERE SQL clause.
Learn about all the various reserved keywords in MySQL.
Learn about how to create a new database in MySQL.
Learn about how to use conditionals in MySQL.
Learn about how to create a table in MySQL.
Learn about the importance of planning in MySQL.
Learn about the SELECT SQL clause in MySQL.