The open source MySQL spin-off has steadily added features all its own. Here are five good reasons to switch to MariaDB. MariaDB may have started as a MySQL fork, following Oracle’s acquisition of ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Auto-increment is a feature in databases that automatically generates a unique number for each new row added to a table. This number is usually used as a primary key to uniquely identify each row in ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...

After upgrading to Gitea 1.13.0, the version in the version table increased to 156. However, I did not detect any changes in the database structure. Maybe this version number doesn't relate to the ...

Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column’s default value at a later date using a single command. This ...