What are the 3 ways to select rows from a query result in SQL? When you need a subquery or a view? Read more in this article!
SQL Language
SQL is the language of data. You write a query, a single sentence in a language that resembles English, and you ...
MariaDB stored procedures and why they should be improved was the title of my talk at MariaDB Server Fest 2023 in ...
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all ...
Reducing the number of queries is important with any DBMS. There are two reasons for this: reducing the latency of applications; and reducing the workload for the database servers.
SQL columns can be NULL or NOT NULL. Let's see what are the good and bad reasons to declare NULL columns.
Vettabase asked the community what is the most dangerous SQL statment. Let's think a bit about it!
Does NULL mean "no value"? Or does it mean "an unknown value"? Its semantics and history are ambiguous and inconsistent.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.