MySQL
Written
Author
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
Include
Learn about the php command "include" and how it's used to connect to a MySQL database.
Last Updated
Data Types
Learn about all the various data types that can be used in and are supported by MySQL.
Last Updated
Joins
Learn about how to use SQL joins in MySQL.
Last Updated
LIKE and NOT LIKE
Learn about how to use LIKE and NOT LIKE SQL clauses in MySQL.
Last Updated
Column Modifiers
Learn about column modifiers in MySQL.
Last Updated
INSERT
Learn about what MySQL's INSERT SQL command is and why you'd use it.
Last Updated
WHERE
Learn about how to use the WHERE SQL clause.
Last Updated
Reserved Words
Learn about all the various reserved keywords in MySQL.
Last Updated
CREATE DATABASE
Learn about how to create a new database in MySQL.
Last Updated
CONDITIONALS
Learn about how to use conditionals in MySQL.
Last Updated
CREATE TABLE
Learn about how to create a table in MySQL.
Last Updated
Planning
Learn about the importance of planning in MySQL.
Last Updated
SELECT
Learn about the SELECT SQL clause in MySQL.
Last Updated