In the previous tutorial, we looked at adding a new column after an existing column in MySQL. That tutorial showed you how to add a new column at any position in a table, except the first. In this tutorial, we’re adding a new column to the beginning of a …

Adding a new column to a MySQL table will put it at the end of the table. When adding a new column to a table you sometimes want to place it at a given position, next to an existing column in the table. MySQL allows you to place a new …

MySQL is flexible in the data model and allows you to have nullable columns. For example, you’re using NULL as the default date-time value until a given action happens. When displaying the data you may want to apply a specific sorting. But if the sorting column allows NULL values, …

An application in production evolves by adding new features. You may also detect inconsistencies from previous developments that you want to improve, such as the naming in your database schema or adjustments in casing. You can rename columns in MySQL easily and this tutorial shows you how. {{outline}} MySQL 8. …

We’re using MySQL as the relational data store in most of our projects. MySQL is a solid foundation, even with complex data types, like JSON. Sometimes we’re integrating apps with external APIs. We typically store responses from external services when requesting from them or synchronizing data with them. …

Storing and working with dates in the database is a common use case. You’re storing data and want to keep a reference of the creation date or when an update happens. MySQL comes with dozens of date and time functions. It facilitates your work when filtering or grouping rows …

It’s a stressful situation when your website isn’t available. In such situations, you're typically checking the application logs for hints. If you can’t find anything in the logs, you have to check the system load, like CPU and memory usage. What process is taking up most of …

We’re working on a running project and want to calculate statistics. For example, how many 10k runs happened during the competition? Or how many half-marathons and marathons did people run? Runners in the event use Strava to track their activities. We’re using Strava webhooks to process and store …