MariaDB SQL Recursive call to self (single table)

If you need to recursively query data based on child / parent relation between rows, you can achieve that using WITH RECURSIVE & UNITE ALL query instructions. Let’s have a look at example “software table”. Software can be declared as virtual machine,...

MariaDB add database user SQL

You more likely know how to create a database user using PhpMyAdmin or some other administrative tool. But sometimes we need to create a database user and add privileges manually. Here is an example SQL which does just that: Adding MariaDB database user, managing his...

WooCommerce SQL query for not empty tags

WordPress query non-empty tags or categories. Query only tags/categories that are assigned to a product. If you need to query tags or categories not particularly related to any tag category or product. You can go ahead and query data directly from two tables: wp_term...