Category "mariadb"

django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

My model: class Course(models.Model): language = models.ForeignKey(Language) name = models.CharField(max_length=50, unique=True, default='course')

MariaDb is installed but could not be imported into python

I tried to install the Mariadb plugin for python. Therefore I downloaded the MariaDB Connector and installed it and then I installed via pip3 the mariadb. And I

MariaDB Import maximum key length

We are currently moving the DB to another Server but we got a problem. Our Database is quite big and when we want to Import it to our new MariaDB Server with Ph

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