Question : I’m using MariaDB ODBC driver version 3.0.2 for Windows(on Windows 10) and can’t get excel (Excel 2013) to […]
Category: MariaDB
LEFT JOIN subquery fails in the presence of an EXISTS clause in the main query
Question : I have this query: SELECT c.id contact_id, engagement.sent FROM contact c LEFT JOIN ( /* ➊ Inner query […]
MariaDB doesn’t set authentication_string during installation
Question : I’m setting up a new server using MariaDB (current stable version of 10.3) and I notice that all […]
MySQL table with a lot of text
Question : So I have this database (Size 3.1Gb total), but this is due to one specific table I’ve got, […]
Anyone understand why this query no longer works? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Repair/Recover data from MySQL database
Question : I have a big problem with a MySQL database stored on my raspberry (InnoDB engine). I’m not very […]
I can’t add an extra node to mariadb cluster 10.1
Question : I was installing a test mariadb cluster but I have a problem when I want to add an […]
How to transition from a statement based log to row based log for Galera replication?
Question : I’m new to clustering and I’m trying to implement a Galera cluster. I’m transitioning from a standalone MySQL […]
How to aggregate in the WHERE clause referencing the subquery from the FROM clause
Question : I got the following query so far: SELECT q1.ID, Content, Volume, CustomerID, runtot FROM ( SELECT ID, Content, […]
Should I use mysql_upgrade after mysqld_safe when upgrading MariaDB?
Question : I’m wanting to know the best practice to do a MariaDB upgrade on opensuse. I am getting this […]