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.
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.
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.
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.
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.
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.
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.
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 on character strings.
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.
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.
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.