Questions tagged [mariadb-10.6]
36 questions
3
votes
2 answers
MySQL/Mariadb problem: `Order by DESC` before `Group by`
Summary: I want to Order by before Group
I find a nice article about the problem, but finally not successful to fix it.
https://eddies-shop.medium.com/mysql-when-to-order-before-group-13d54d6c4ebb
My Server config:
Server type: MariaDB
Server…
Max Base
- 639
- 1
- 7
- 15
2
votes
1 answer
Delete random rows in table but left fixed amount of entries
I have a table with unknow number of rows in it. I need to remove all the rows, except a fixed number of records.
Example: Table 1 has 439 rows. I need to keep 200 rows randomly and delete others.
The "logic way" is:
DELETE FROM table_1
WHERE id…
Matt Ross
- 67
- 7
2
votes
0 answers
MariaDB unable to start after update to version 10.6.5
i have just updated my maria db version to 10.6.5 and when i start apache is starts very well but when i start MySQL it doesn't rather..i have followed all the steps in updating the version but i cant really understand why its unable to start..here…
stephen waweru99
- 151
- 15
2
votes
1 answer
Maria DB docker Access denied for user 'root'@'localhost'
I'm using a MariaDB docker image and keep getting the Warning:
[Warning] Access denied for user 'root'@'localhost' (using password: NO)
This is my docker file used to create the image:
FROM mariadb:10.6.4
ENV MYSQL_ROOT_PASSWORD pw
ENV…
WhatTheWhat
- 197
- 3
- 13
1
vote
2 answers
any alternative to mysql left join copy table_B content in table_A without duplicates
Given the two tables:
create table table_A (col1 int, col2 int);
insert into table_A values(10,10);
insert into table_A values(15,15);
insert into table_A values(35,35);
insert into table_A values(45,45);
create table table_B (col1 int, col2…
Mircea Cristian
- 13
- 2
1
vote
1 answer
Cannot save emojis in utf8mb3 tables… Overnight, since MariaDB 10.6 update and switching to nd_mysqli
Before, using MariaDB 10.5 and mysqli, I had plenty of old WordPress website on utf8mb3 tables where I can successfully save a wide range of Emojis in the database.
Now since I switched to MariaDB 10.6 and nd_mysqli, if the database and tables are…
1
vote
0 answers
Loop import XML files
I'm using MariaDB to import some files in XML.
Here is a snippet of the code I'm using:
CREATE TABLE invoices (
InvoiceNumber VARCHAR(20),
InvoiceStatus CHAR (1),
InvoiceDate CHAR (10),
Period CHAR (2)
)
;
DROP TABLE if EXISTS…
Bruno
- 88
- 5
1
vote
0 answers
Unescape JSON strings with JSON_TABLE in MariaDB
I have trouble with the JSON_TABLE function in MariaDB 10.6.5. This is my query:
SET @data = '[{"Data": "
Louis
- 215
- 1
- 9
1
vote
1 answer
Mysql GROUP BY ...but I want the oldest one
I would like to group my results by category when there is one but also that the user in the group is the oldest, but I can't decide which one...
|NAME |DATE |CATEGORY |ID
|bill |2021-12-24|NULL |6
|adrian|2021-12-23|NULL …
rudak
- 379
- 3
- 16
1
vote
2 answers
Migration from MySQL 5.6.35 to MariaDB 10.6.3 - Queries not working
I recently migrated DB servers from MySQL 5.6.35 to MariaDB 10.6.3
I have found that few queries which used to run quick on MySQL is now very slow or not working in MariaDB.
It gives:
Error Code: 2013. Lost connection to MySQL server during…
Sims Susee
- 11
- 4
0
votes
0 answers
How to extract Nested Json Keys in Mariadb?
I have this json file
{
"data": {
"Header": {
"num": 1000095371,
"name": "1000095371 LE"
},
"character": {
"b1234": {
"ID": 1
},
"b1256": {
"ID": 2
},
"b12389": {
…
Bala
- 1
- 1
0
votes
0 answers
Invalid DB type - DATETIME /* MARIADB-5.3 */
Recently have upgraded the MariaDB version to 10.6.11-MariaDB from 10.2.13-MariaDB.
Whenever we execute related jobs, getting below error
Error Code :- 100.123
Error Message :- Invalid DB type - DATETIME /* MARIADB-5.3 */
[2023-07-04…
0
votes
0 answers
How to get data from a LONGTEXT to perform string operations
I have some MariaDB code, which I'm fairly new to. I'm a seasoned MSSQL developer, however. I have a script with a variable which I'm setting to what will eventually be the contents of a file. This it is 51k characters long and ends up being a…
Mark Roworth
- 409
- 2
- 15
0
votes
0 answers
mariadb gives error for unknown column in subquery but mysql runs fine
Like the title suggests I have a query that runs fine in mysql but gives error with mariadb:
[42S22][1054] (conn=38) Unknown column 'ME.membershipId' in 'where clause'
The script that can be run to test the problem:
create database demo;
use…
Hannes Härm
- 91
- 7
0
votes
3 answers
Join two tables in Maria DB generating new columns
I need to join two tables in MariaDB in a specific way. For each project in table A I need to add one column for objective 1 and one column for objective 2. The value of objective 1 and objective 2 is the value of the field is_core associated with…
Jesus Paradinas
- 189
- 2
- 12