FB
mysql enum

MySQL ENUM: The Ultimate Guide

The ENUM data type in MySQL is a helpful data type for specifying a valid range of values. In this guide, you’ll learn all about the MySQL ENUM feature, including: what the ENUM feature is how to use it on your database some disadvantages of this feature Let’s get into it.

mysqldump

Use mysqldump to Backup and Restore a MySQL Database

If you’re interested in the process to backup and restore a MySQL database, then mysqldump is the tool to use. In this guide, you’ll learn: what mysqldump is how to use it to backup your database in different ways how to restore your database from a backup file Let’s get into the guide.

MySQL Pivot

MySQL Pivot: How To Generate a Pivot Table

Do you want to learn how to generate pivoted data or pivot tables in MySQL? In this article, you’ll learn: what the pivot concept is how to generate a pivot table in MySQL how to generate the column headings dynamically Let’s get into the guide.

flyway db

Flyway DB Tutorial: How to Set Up Flyway

If you want to set up Flyway DB on your database, you’ve come to the right place. In this guide, you’ll learn: What Flyway is A step-by-step guide to setting it up on your database Create a couple of SQL scripts to demonstrate the process Let’s get into it.

github tutorial

GitHub Tutorial for SQL Files

Do you want to, or need to, learn how to use GitHub for your SQL files? GitHub is a commonly-used service for application development. But it can also be used for your SQL scripts and other files used in development.

sql developer import csv featured

SQL Developer Import CSV: How To

If you’re using SQL Developer, there may be a time where you want to import a CSV file into your Oracle database. SQL Developer includes a wizard that lets you import a file. Let’s see how to use it in this guide.

mysql data export featured image

MySQL Workbench Export and Import Database: How To

Are you using MySQL Workbench and want to export your database? Or do you have an export file and want to import your database? In this guide, you’ll learn how to export a database and import a database in MySQL Workbench, with screenshots and step-by-step instructions. Let’s get into it.