Question : I have this query: SELECT c.id contact_id, engagement.sent FROM contact c LEFT JOIN ( /* ➊ Inner query […]
Tag: mariadb-10.3
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 […]
Query joining four tables resulting in one row
Question : I have these two queries which pull data from four tables: select files.id, files.name, dirs.dir from files inner […]
How to lock all tables except some specific table?
Question : I am trying to set a stage server which replicate some tables like articles, user etc from master. […]
fix InnoDB: corrupted TRX_NO after upgrading to 10.3.31
Question : After upgrading mariadb from 10.3.25 to 10.3.31 it fails to start like described in this bug report I […]
Mysql: Unable to drop a columns NULL default
Question : Running mariadb 10.3 I have a bunch of columns that were created by default as NULL defaults. I […]
SELECT from table without blocking INSERTs into it?
Question : I have an application where each page load inserts information about the visit into a MariaDB table. There […]
How to get more connections for mariaDB or how to reduce RAM usage per thread?
Question : We have an MariaDB 10.3 database server running on an 8 core and 64GB RAM machine. The database […]
MariaDB CONNECT engine to read external mongodb collections
Question : I want to access MongoDB collections through MariaDB 10.4.17. Both are installed on my local machine running Windows […]
ERROR 1067 (42000): Invalid default value for ‘uploadedDate’
Question : Hi everyone i am getting an error trying to run the below query ERROR 1067 (42000): Invalid default […]