If you’re trying to add a generated column in SQLite, and you’re getting the “cannot add a STORED column” error, it’s probably because you’re trying to add a stored column.
In SQLite, we can only add virtual columns to existing tables.
Relational
Subtract Hours from a Time Value in SQLite
In SQLite, we can use the TIME() function to subtract one or more hours from a time value.
For datetime values, we can use the DATETIME() function.
3 Ways to Get the Start of the Month in MariaDB
Here are three options for returning the first day of a month in MariaDB.
This could be the first day of the current month, or the first day of the month based on a date that we specify.
Return Only Numeric Values in SQL
If you ever need to use SQL to return just the numeric values in a character column, the method you use will largely depend on your DBMS. Most DBMSs support regular expressions (regex), but some don’t. And some include functions that can detect numeric values.
Here are examples of how to do it in the more popular DBMSs.
MariaDB CASE Statement
In MariaDB, the CASE statement can be used in stored programs to perform a complex conditional construct. It compares a list of conditions and returns a different result depending on which condition (if any) is matched.
The CASE statement is distinct from the CASE operator, in that the CASE statement is specifically for use in stored programs. Also, there’s a slight difference in the syntax.
3 Ways to Get the Definition of a Generated Column in SQLite
When we have a table with a generated column, here are two methods we can use to return its definition.
How NVL2() Works in MariaDB
In MariaDB, the NVL2() function allows us to replace a value with another value, the new value being determined by whether or not the initial value is null.
It’s similar to the NVL() function, except that NVL2() accepts three arguments instead of two. This allows us to specify a different value to return in the event the first argument is not null.