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.
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.
In this article, you’ll learn: what the PIVOT feature is in SQL Server a few examples of using PIVOT how to use the UNPIVOT feature Sometimes you’ll need to pivot your data if it’s stored in a different way to how you’d like it displayed. You can use the SQL Server PIVOT feature to do …
SQL Server PIVOT and UNPIVOT Explained with Examples Read More »
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.
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.
If you’re working with PL/SQL code and processing multiple rows, there are two techniques you can use to improve the performance of your code. These techniques are BULK COLLECT and FORALL. In this guide, you’ll learn what these techniques are, see examples of them, and see how they can improve the performance of your code. …
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.
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.
In SQL, you may need to find out more about the table and its columns. This is often called “sql describe table” or describing a table. Different vendors (Oracle, SQL Server, MySQL, PostgreSQL) have different methods for letting you see this information. In this post, you’ll learn how to see the table details using the …
Have you ever needed to calculate a “running total” or “cumulative sum” in SQL? You can do this in SQL without any other programming language to process the data. In this guide, you’ll learn how to calculate a running total in SQL. This method will work in Oracle, SQL Server, MySQL, and PostgreSQL. We’ll look …
