General Guides MySQL Tutorials

MySQL Database Instructions
You can create up to 4 MySQL databases using the "Add MySQL Database" function of your Control Panel.

MySQL Basic Commands
Learn basic mySQL commands.

MySQL System Architecture
In this article, we're going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together.

Select Record
This tutorial will show you how to get records in your table in database to show on your PHP files. This SQL statement has many options.

Insert Record
This tutorial will show you how to insert data into mysql database.

Create Database and Table
Basic steps on how to setup a mysql database. Includes creating a tables, adding tables, and exporting a database.

Using MySQL to analyze web usage from Windows ISA logs
This tutorial will teach you how to import a tab delimited file in to a MySQL database. We built a program to do this for Windows ISA Server logs which contained over 500,000 lines which was way too many for Microsoft Excel to handle and too much for notepad to handle properly.

What is MySQL?
MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use.

Introduction to MySQL database
MySql is a powerful database. This tutorial will explains an introduction of MySQL database.

Creating Users and Setting Permissions in MySQL
MySQL is an extremely powerful database, but in order to properly maximize its potential you may need to learn how to set up users and their respective permissions. In this article take a look at using the MySQL console application to create users and grant permissions to them. We also shows us how to grant permissions from remote hosts, how to reduce user privledges and more. MySQL is an extremely powerful database, but in order to properly maximize its potential, you may need to learn how to set up users and their respective permissions.

MySQL Made Easy With MySQL Front
MySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial see how to get up and running with MySQL Front.

Introduction and Features
This is a free online sql tutorial that focuses on MySQL.

MySQL Basic
This mysql tutorial covers the basic stuff that you can do with MySQL.

MySQL System Architecture
We are going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL's implementation is a fascinating mix of technology that is truly a remarkable achievement - an achievement born from the sweat and inspiration of numerous developers overmany years.

Introduction to MySQL
MySQL is the most popular open source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.

MySQL DELAY_KEY_WRITE Option
Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed.

MySQL Command Line Help
We tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command mysql to start). We noticed today that there is a pretty extensive built in help system in this command.

Improve The Performance Of Your MySQL Server
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! Learn how to get the best performance from you MySQL database server.

Building a High-Availability MySQL Cluster
Serious business services really can't go down, whether due to hardware or software failures. If your necessary services rely on MySQL, clustering and high availability can prevent failures. How MySQL Cluster and Heartbeat to provide redundant, failure-proof replication and availability of their data.

How fast can you sort data with MySQL?
See how much MySQL can sort 1.000.000 rows, or rather return top 10 rows from sorted result set which is the most typical way sorting is used in practice.