IT, MariaDB, MSQL, SQL
Adding numbering to not sorted query. If your query is not sorted, adding a number to a query can be as easy as: SELECT ROW_NUMBER() OVER() AS num, This will work if you will not use ORDER BY clause in your query: If you add ORDER BY clause, things work differently....
IT, MariaDB, mysql, SQL
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,...
database, MariaDB, mysql
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...
Ta strona korzysta z ciasteczek aby świadczyć usługi na najwyższym poziomie. Dalsze korzystanie ze strony oznacza, że zgadzasz się na ich użycie.Zgoda