MySQL Tutorials

Welcome to our MySQL Tutorial section. This will provide you a comprehensive MySQL lessons and tutorial along with practical examples.

MySQL One Liners

You will find a collection of one-line commands for MySQL here.

MySQL FULLTEXT Searching Tutorial

Here, you will find a tutorial that shows how to perform MySQL Fulltext searching. This allos database administrators, programmers easily designate any (CHAR, VARCHAR, or TEXT) character-based field as a FULLTEXT index

MySQL Sub Queries Tutorial

This section will teach you how to write subqueries in MySQL. MySQL TutorialsSubqueries can do advanced queries against the usual database query. With this, you won”t have to do that much logic in your chosen programming language.

Backup MySQL with Cron Jobs Tutorial

Want to learn how to back up MySQL with Cron Jobs? Everything is in here. You will learn how to make a Cron tab and use it within Cron Jobs installed on Cpanel.

MySQL Tables Optimization Tutorial

This section will show you how to  set up an automatic optimization for your database. MySQL Tables Optimization  helps in cleaning up and getting the best possibilities in gathering the needed information.

MySQL DB Backup/Restore Tutorial

This tutorial will show you how to backup and restore data in your MySQL DB. You will learn here here how to use MySQLDump – which is the fastest and easiest way to back up and restore a database.

Using a MySQL database with PHP Tutorial

Learn how to use a MySQL database with PHP using this tutorial!

Optimizing MySQL Queries and Indexes Tutorial

This tutorial will guide you on how to optimize queries and indexes using MySQL. You need to optimize your database when queries are queuing up, users are being refused of the connection, or the backlogs are growing.

Database Replication In MySQL Tutorial

This section will teach you on MySQL replication. Database replication in MySQL will allow you to create an exact copy of the database from a master server onto another server [slave]. Every updates in the database on the master server are immediately replicated to the [slave] server so that both of them are in sync.

Working with Stored Procedure Tutorial

This section will teach you on creating & calling stored procedures in MySQL.

Triggers Tutorial

This tutorial will show you everything about Triggers. You will learn how to create triggers in MySQL using this tutorial. Just so you know, when creating a trigger all you need is to specify 4 pieces of information:

  1. The unique trigger name
  2. The table to which the trigger is to be associated
  3. The action that the trigger should respond to (DELETE, INSERT, or UPDATE)
  4. When the trigger should be executed (before or after processing)

Create Your First MySQL Database

This section will show you how to create your very first MySQL database via cPanel.