Here's what I use: lsb_release -a Distributor ID: Ubuntu Description: Ubuntu 22.04 LTS Release: 22.04 Codename: jammy uname -r 5.10.102.1-microsoft-standard-WSL2 Operating system Windows 11 Pro * version 21H2 * build 22000.708 * experience Windows Feature Experience Pack 1000.22000.708.0. Here are…
We have recently migrated a PHP web application to a different hosting. Along with that, the database was also successfully copied over to the new mysql server. The earlier version of database server was mysql5.6 and the new hosting has…
After do a images rm, volumes rm and docker prune i got this error starting mariaDB on with docker-compose This is the db compose part (yml): mariaDB: image: 'mariadb:latest' environment: - MYSQL_ROOT_PASSWORD=root_password The error log: mariaDB_1 | 2022-05-27 20:14:42+00:00 [Note]…
How can I convert this to normal query? WITH cte AS ( SELECT agentID, SUM(bonus > 0) OVER (PARTITION BY agentID ORDER BY `year` * 12 + `month` RANGE BETWEEN 2 PRECEDING AND CURRENT ROW) flag FROM test ) SELECT…
my problem here is that I've got no idea of SQL queries but need to do something I'm assuming should not be hard. I've tried some of the recommended questions but I just can't really understand how to extrapolate it…
I am trying to create a stored procedure in MariaDB, and I keep getting the error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax…
I have a strange problem: There is a price in a JSON column in a table and the following statements give different results while they should give the same thing: CAST(COALESCE(JSON_EXTRACT(item.price_details, "$.shipping.price"), 0) AS FLOAT) AS shippricecoalfloat COALESCE(CAST(JSON_EXTRACT(item.price_details, "$.shipping.price") AS…
I have an existing table that has many rows something like this: id Product Tel1 Tel2 Tel3 Tel4 1 A 1234 1234 1234 1234 2 B 1234 1234 1234 3750 3 C 1234 1235 1234 1234 4 D 1234 1234…
We are currently moving the DB to another Server but we got a problem. Our Database is quite big and when we want to Import it to our new MariaDB Server with PhpMyAdmin. We got an Error Code and don´t…
Working on Debian 11 (Bullseye) first with the distribution's MariaDB version 10.5 and now with the version 10.6.7 from MariaDB repositories. I'm failing to get correct indexes for some big tables from the dump of a genetics database (ensembl homo_sapiens_variation_106_37)…