Category "mariadb"

how to validate date null in mysql?

I'm working with MariaDB. when I try to show some result don't show me nothing. select if(fecha is null,'hello','bye') dat from table I'm trying to

MariaDB - is it possible to index JSON arrays?

When working with JSON in MariaDB it is possible to index single-point values using virtual columns e.g. ALTER TABLE features ADD feature_street VARCHAR(30) AS

Get full tree of parent/child relationships in mysql of any node in the tree with all parents

Example data: +----+-------+----------+ | org_id | Name | ParentID | +----+-------+----------+ | 1 | Org1 | 2 | | 2 | Org2 | NULL | | 3 | Org3

Debian 10 MariaDB 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Good evening Community, I am in despair because I cannot install MariaDB on Debian10. There are similar Stackoverflow questions but none of them helped to solv

MariaDB - Cannot connect to MariaDB instance from Dbeaver using correct password

I am trying to connect to a localhost instance of MariaDb on port 3306. I'm well aware that root cannot use localhost because of MariaDb specifications so I cre