MariaDB supports INSERT RETURNING and DELETE RETURNING, which help avoid an additional SELECT.
Read moreDo languages need NULL? – Rust example
Rust shows the correct way to implement NULL in a programming language.
Read moreMySQL danger: comments and ALTER TABLE
In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.
Read moreWhen to use NULLable columns in relational databases (→Vettabase)
There are cases when using NULL in an SQL database is desirable. However, there are always alternatives.
Read moreOptimising or fixing SQL queries: how to ask for help
If you need free help or paid support, you should phrase your questions correctly and provide the necessary information.
Read moreWhat does NULL mean in SQL? (→Vettabase)
Does NULL mean “no value”? Or does it mean “an unknown value”? Its semantics and history are ambiguous and inconsistent.
Read moreNULL comparisons in MySQL, PostgreSQL, and SQLite
Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons.
Read more