How to open and transpose list in MySQL
I have a given dataframe: id listofnumbers 2 [1, 2, 5, 6, 7] 5 [1, 2, 13, 51, 12] Where one column is just id, and the other one is list of number made like that which i got previously…
LOAD DATA LOCAL INFILE file request rejected due to restrictions on access (ODBC) – Mysql
Oh my, how do I even start asking this question.... I have a feeling this has been answered more than ones but I'm too dumb to understand the answers.... So I'm sure I'll be roasted for lots of reasons, but…
MySQL – Return from function only if single row matches
I have a MySQL table of users as follows: CREATE TABLE `users` ( `ID` INT NOT NULL, -- NOTE: in practice, I'm using BINARY(16) and -- the UUID()-function to create user IDs. -- 'INT' is only a simplification for this…
Select row if at least one possible SUM of its children equal a given number? – PHP
I am trying to filter a set of appartments by computing every possible surface the building has got, and then checking if it matches my criterias or not. Example : I have one building A that is composed of 3…
mariaDB 10.5.8 very slow stored view after moving to newer version – Phpmyadmin
I would like to ask for help as I'm struggling to understand this issue. I have two databases main and backup. Both have same data and views. Main is inside VM on QNAP NAS (v10.5.5) and backup is on same…
MySQL select from multiple tables, keep all columns and row without match
I have 2 tables tableA: id dateA colA ... 1 2022-11-11 12:00:00 A 2 2022-11-12 12:00:00 B 3 2022-11-14 12:00:00 C tableB: id dateB colB ... 3 2022-11-05 12:00:00 D 4 2022-11-06 12:00:00 E 5 2022-11-13 12:00:00 F and I…
Can MySQL/MariaDB stop doing a selection by reaching certain condition? Or select all rows before condition
For example, I have table id;name 1;John 2;Mary 3;Cat 4;Cheng I want selection to stop right after 3;Cat and still have as much rows in it as exist berore 3;Cat I think this could be described with such a query…
What the meaning of `uint4korr` in the MySQL?
I notice there is a macro uint4korr in the MySQL/MariaDB source code. include/byte_order_generic.h I merely understand this macro is correlated with byte order. But I looked for the comments about this macro, found nothing. I don't know the meaning of…
Mysql – MAX() slow query
I have this query to fetch most recent conversations grouped by phone number, however the query time is too slow. How can it be faster? SELECT * from messages WHERE id IN (SELECT max(id) from messages GROUP BY phone) AND…
Mysql – MariaDB utf8mb4_0900_as_cs collation error
I'm trying to switch to MariaDB from mysql 8. I downloaded latest MariaDb 10.10.1 RC version, trying to import backup created from mysql using mysqldump and I get the following error Unknown collation 'utf8mb4_0900_as_cs' What is the equivalent collation in…