mariadb-10.2 is an open source database server that offers Window Functions for Analytical Queries.
Questions tagged [mariadb-10.2]
28 questions
0
votes
1 answer
MariaDB has stopped responding - [ERROR] mysqld got signal 6
MariaDB service was stopped responding all of a sudden. It was running for more than 5 months continuously without any issues. When we check the MariaDB service status at the time of the incident, it showed as active (running) ( service mariadb…
Chana
- 56
- 8
0
votes
2 answers
Split column datetime values with into multiple columns
With a MySQL query, how can I take a table like in Example A:
Example A
ID
time
log_type
1111
2021-06-01 07:13:42.000000
IN
1111
2021-06-01 17:13:42.000000
OUT
1111
2021-06-03 07:00:42.000000
IN
1111
2021-06-03…
Ashanti
- 3
- 3
0
votes
1 answer
Error when inserting Hungarian text characters
I'm trying to insert this text via SQL query
INSERT INTO `tbl_instructions` (`No`, `Language`, `Text`) VALUES
('Introduction','HU','Kérdőív - ""Ismerd meg Önmagad!"" Ahogy az ókori görögök mondták: ""Ismerd meg Önmagad!"" - Ez a célja ennek a…
Dev Dev
- 314
- 4
- 17
0
votes
1 answer
How to use the word 'recursive' as a column name in MariaDB 10.2
In my TYPO3 v7.6 installation, I have an SQL script with the following line:
recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
This tries to create a column named 'recursive'.
Unfortunately, recursive is a reserved keyword since MariaDB 10.2. I…
janisch
- 159
- 1
- 1
- 13
0
votes
1 answer
SELECT the first date in which 3 consecutive entries are between two dates
I would like to know the first date of the first 3 consecutive entries that are between two dates. Based on my SQLFiddle, I would expect the output to be '2021-01-24'.
I've looked at many examples but can't get them to work.
This query is not…
Tim M
- 306
- 3
- 18
0
votes
3 answers
Running total of every increment
I have a table events as follows:
f_id leg
1 1
2 1
3 1
4 2
5 2
6 3
7 1
8 1
9 2
I want a running total of every time the leg changes. Expected output:
f_id leg total_legs
1 1 …
arsenal88
- 1,040
- 2
- 15
- 32
0
votes
0 answers
MySQL query timing out only with specific column selected and WHERE JSON_CONTAINS()
Consider the following queries:
SELECT uID, name FROM table WHERE JSON_CONTAINS(email, '{"key": "email@email.com"}', '$');
SELECT uID, name, history FROM table WHERE JSON_CONTAINS(email, '{"key": "email@email.com"}', '$');
SELECT uID, name, history…
0
votes
3 answers
Remove duplicate MySQL entries
I've not seen anyone ask for help with this specific issue.
I've got a table with 300,000 rows in it. Each row has a unique id, several columns but there is no timestamp etc.
The issue I have is the user has managed to import new data in to the DB…
Tom
- 1,436
- 24
- 50
0
votes
1 answer
Increment query takes long time to execute in MariaDB
The query below takes 0.005secs to 7secs to execute on the production server database but max 0.010 secs on the local database. Don't know what's wrong with the query.
Query:
UPDATE tbl_entrance_exam_report_info SET…
Kapil
- 139
- 2
- 13
0
votes
1 answer
Long query execution - SSP Datatables
I use Datables with SSP Class. And i have query with result 2000 lines.
But when I try running query I got error 500/504 error (if I have 504 table is didn't load)
I use OVH CloudDB with MariadDB 10.2 and on server I have php 7.2
My joinQuery looks…
Patryk Tchórzewski
- 125
- 2
- 16
0
votes
1 answer
SQL INSERT is not working with OUTPUT INSERTED statement
My goal is to insert a new row in a database table and immediately get back the ID of the inserted row.
I saw some other posts on stackoverflow that suggested to use this command:
INSERT INTO selecttable (name) OUTPUT INSERTED.ID VALUES…
Blackbriar
- 477
- 4
- 14
-1
votes
1 answer
Dapper error when deserializing to complex object
I'm trying to convert a "flat" query into a complex object. The query returns custom_height and custom_width which I would like to be a child object off of the main Panel object being serialized. When I attempt to use splitOn to achieve this, I am…
Joe Phillips
- 49,743
- 32
- 103
- 159
-1
votes
1 answer
Galera Cluster 2 nodes - Unable to restart MySQL server on node 1
i am experiencing this issue, similar to this one:
Unable to restart MySQL server
but i not sure how to proceed so i am asking to the community especially with someone with more experience than me on Galera Cluster.
I'll try to…
