How To Use MySQL Triggers


MySQL triggers provide control over data validation when inserting, updating or deleting data from a database. Learn how to use triggers through an example database and when to use each type of trigger.

Read More

MySQL Data Types


Data types are important to understand as a name and a data type define each column in a database table. Learn all about MySQL data types and when to use them in this comprehensive guide.

Read More

MySQL Date Function Guide with Examples


Find a list of all MySQL date functions in this helpful article. Learn what each function does and how to use it through the practical examples.

Read More

MySQL Commands Cheat Sheet


Need a reference sheet for all the important MySQL commands? Check out this MySQL Commands article which includes a downloadable MySQL cheat sheet in PDF format.

Read More

How to Create a Table in MySQL


MySQL is a well-known, free and open-source database application. One of the most crucial processes in MySQL is creating tables and databases. Follow this tutorial to learn how to create a table in MySQL and insert data.

Read More

How to Create or Add an Index in MySQL With Examples


An index is an integral part of MySQL, helping with organizing and searching information more easily. This guide explains how to add an index to new and existing tables, as well as how you can display an existing index.

Read More

How to Drop a Table in MySQL


The DROP statement is a simple method to remove entire tables from your databases. It provides several versatile options that allow you to automate specific tasks. This tutorial also shows how to create a custom piece of code to remove tables based…

Read More

How to Import a CSV file into a MySQL database?


The article explains how to import a CSV file into a MySQL database using the command line or phpMyAdmin. Also, find out how to exclude the header row from the CSV and speed up the importation process.

Read More

How to Install and Configure MySQL on a Windows Server


The article provides many images that guide you through each individual step of a MySQL installation on Windows. The elaborate setup is made easy with clear instructions and concise descriptions of each particular option.

Read More

How to Export a Table from MySQL to CSV


This article explores several highly efficient methods that allow you to export a MySQL table as a CSV file. As a CSV file, the data from your tables becomes much more accessible, both to humans and a host of other applications.

Read More