Let’s see how to change a user’s password or your own password in PostgreSQL. We’ll also discuss how to avoid sending the password in clear over a network.
Let’s see a slightly elaborated “Hello world”, to demonstrate the most common SQL operations with MariaDB: creating a database and a table, inserting a row, reading it, modifying it, deleting it.
There are several ways to concatenate strings in SQL, and they mainly differ in how they handle
Some DBMSs, like MariaDB and MySQL, allow to create
UNSIGNED columns. SQL Server doesn’t support unsigned integers. Let’s see what we can do instead.
PostgreSQL allows to create, read and write tables without columns. Let’s see how to work with them, and whether they can have practical uses.
Simple examples of SQL stored procedures in Db2.
Let’s see how to check what a user can do with a certain PostgreSQL table, or which users have a certain permission on a table.
In MariaDB most errors cause the current transaction to rollback, but warnings don’t. This article shows how to rollback when a warning happens.
SQL Server allows to handle errors with
TRY ... CATCH blocks, and provides several statements to get information about the error that is being handled.
Db2 supports three different hash functions, and each of them can use different algorithms. Let’s shred some light on them to understand their use cases.