I want to reserve the order of a MariaDB table. I actually want the table to change not just output the data in reverse order. So I want the row at ...

I am trying to connect to a MariaDB database from a C# Console App using [email protected] running Net7.0 on Ubuntu 22.04 . MY CODE using System; using...

This is my first stackoverflow post, I am currently working on a project for school, but unfortunately I can't get this bug fixed. I have a node.js sc...

I seem to have some problem with encoding, but I can't pinpoint it. PHPMyAdmin says: Server type: MariaDB Server version: 10.3.39-MariaDB-log - MariaD...

For security issue, I need to check whether I can create mariadb procedure in other schema, rather than mysql.proc. If it is possible, I would greatly...

I have a MariaDB table with 28 million rows. I need to update all the rows (locally) with a new value in a column. This is the code in Python to batch...

My issue is the following: I have created a user in MariaDB who has global privileges with the following command: GRANT ALL PRIVILEGES ON *.* TO 'user...

I had a MariaDB query utilizing the new, JSON functions, the query suddenly stopped working as the number of rows increased. When digging deeper into...

I have a scenario whereby I am trying to fetch a user's most recent messages from over 2 million rows and group them by their parent (or thread) id. H...

I create a table with a text column with unique key: create table a(id int auto_increment key,a text unique); And when I run show create table a;, it ...

I want replace in a column UTF8 characters with others UTF8 characters, using a PHP form and REGEXP_REPLACE in MySQL/MariaDB. $search = mysqli_real_es...

I am using SvelteKit, Vite.js, and the mariadb package with Node.js in my application. I have the following code in the db.js file: import mariadb fro...

I am trying to test different ways to move 1M data from one table to another without locking the whole tables and then mark the rows as processed. I h...

I am trying to upgrade MySQL 5.6 to MariaDB 10.5 on my Ubuntu 20.04 desktop. I have removed the MySQL per directions (unlinking /usr/local/mysql). I h...

I am deploying an application with the following technologies: (Laravel+MariaDB+phpMyAdmin) In the dockerfile the application image is created and in ...

I am moving an application from MariaDB to PostgreSQL. I have a query that uses GROUP_CONCAT on DISTINCT values of col1 that are ordered by col2. This...

I'm observing a strange behavior on a particular query executed on MariaDB (v10.6.12), and I'm not able to explain that. The table is created as: CREA...

I installed mariadb using ansible and I would like to change the root password which is empty by default. On the net, there are a lots of pages explai...

Suppose we have two tables with the following values: ID Name Fname 1 aaaa aaaa 2 bbbb bbbb 3 cccc cccc 4 dddd dddd ID AnotherId ...

I am attempting to create a MariaDB container for a workflow on GitHub. The workflow file is: name: Rails 7.0 Test with MariaDB on: workflow_dispat...

we are not able to install Shopware v6.5.4.0 (PHP 8.2.8) with MariaDb. Tested with version: 10.5.22-MariaDB-1:10.5.22+maria~ubu2004 mit PHP-Erweiterun...

We have a stored procedure in MariaDB that runs fine on the server, however when we run it from a client with JDBC we get the first rows but later it ...

I have successfully installed mariadb and mariadb-connector-c on Mac OS Monterey using Homebrew but cannot figure out how to compile a simple c source...

I'm trying to remove a lot of rows My query is pretty simple but there is a JOIN and LIMIT is not allowed with that. I don't really understand why sin...

Working fine on Amazon Linux with Intel arch but not on ARM. I have followed one of the many guides like this one: https://techviewleo.com/how-to-inst...