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. …

Working with dates may involve checking whether a given date is a weekday or a weekend. For example, you don’t want to send an email on weekends but on weekdays, and vice versa. This tutorial shows you how to determine whether a given JavaScript date is a weekend or …

The nano text editor is included in Debian-based operating systems. Because Ubuntu is based on Debian you’ll find nano pre-installed as well. The nano editor comes in handy when working in environments where you don’t have a user interface. For example, in server environments or using remote connections …

Typically we’re cloning a git repository into a dedicated directory. The cloned directory then has the name of the repository which, by default, is the repository’s slug. You may also define the directory name in which the git repository’s contents will be cloned. Recently we prepared the …

The ls command is essential when navigating a file system. ls displays files and directories in a given file system path. Yet, there’s a nuance when displaying files using the plain ls command: it’s not listing dotfiles. Dotfiles are the “hidden” files on your hard disk that start …