Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.4]

MariaDB 10.4 is an open source database server that offers drop-in replacement functionality for MySQL. Use this tag only when using MariaDB version 10.4.*

MariaDB 10.4 version was released in June 2019. It implements notable features such as instant DROP COLUMN and ordering change in InnoDB tables; Account Locking; User Password Expiry etc.

Complete list of changes and improvements can be seen here: https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-104/

156 questions
0
votes
1 answer

Remove duplicate records from mysql table

I am trying to delete some duplicate records from mysql table but it was not working. I am taking help of https://www.javatpoint.com/mysql-delete-duplicate-records If I will try with example database which is given example it was working fine. But…
Manoranjan Jena
  • 117
  • 7
0
votes
2 answers

Get data from same row with MAX()?

[MariaDB 10.4, PHP8.0] How can I rewrite this so it works so it get weight_date from the row with MAX(total_weight) and list it AS highest_weight_date? I have read that we can't use MAX() among with WHERE? I have tested to rewrite several examples,…
bollob
  • 27
  • 7
0
votes
1 answer

How to convert an object into a JSON_TABLE in MariaDB?

I have a products table which contains a JSON column product_logs. Inside of this, it contains something similar to: { "c8eebc99-d936-3245-bc8d-17694f4ecb58": { "created_at": "2022-05-08T15:33:33.591166Z", "event": "product-created", …
Jaquarh
  • 6,493
  • 7
  • 34
  • 86
0
votes
0 answers

MySQL.exe won't open?

I just installed the latest XAMPP with the MariaDB 10.4.24 version on Windows11 latest build. The installation was completely fine except that i got a prompt that says I need to deactivate the UAC if i want to install it in directory C. But i ignore…
Muhammad Abdul Azis
  • 1
  • 1
0
votes
0 answers

Mariadb 10.4.24 status shows [Warning] Access denied for user 'root'@'localhost'

When I run the command sudo systemctl status mariadb I get the following screen with a warning in red. This happened when I did an upgrade from Mariadb 10.3 to 10.4.24 This is my.cnf. I am not sure if this warning will have consequences. I am…
jkikuyu
  • 1
  • 1
  • 3
0
votes
1 answer

Packet sequence number wrong - got 1 expected 0

Getting the below error in MariaDb and its causing timeout issue : Debugged it with removing skip-name-resolve, granting privileges to user@localhost, and in pyton create_engine used pool_pre_ping = True and pool_recycle=3600 but nothing seems to…
Smitha
  • 43
  • 1
  • 4
0
votes
1 answer

How can I concatenate text in one row?

I'am using MariaDB and I can do this: `SELECT file_target FROM oc_share WHERE uid_initiator = 'aaa329'; +--------------------------------+ | file_target | +--------------------------------+ | /2012 | |…
andraki
  • 1
  • 2
0
votes
1 answer

Maxscale, ranks and priority

I'm using a maxscale (6.2) readwritesplit router with 3 galera servers (mariadb 10.4). 2 of them are in DC1, and a 3rd one is on a distant DC2. Using ranks is the only option I see here, as priority will be used by galeramon to select the master. My…
CrazyRabbit
  • 251
  • 3
  • 10
0
votes
2 answers

CodeIgniter 3 query not returning null or 0 when records are not available

CI3.1.11 query not working Am trying to filter records between two dates. You can check my code sample here https://pastebin.com/5UhnAG6e instead of giving me 0 when the date range is not available in DB it pulls records from another year. when i…
Robins Harawa
  • 1
  • 4
0
votes
1 answer

Query to retrieve recursively parent child nested list joining to another two tables MySQL-PHP

I've 3 tables and I want to joint them based on the following conditions. My first table is called components it has the main parent and it has a sub-component called sub_compnents which holders the component_id from the parent. The third table is…
Girmangus Hailu
  • 59
  • 8
0
votes
2 answers

How to store status of rows in MySQL according formalization rules?

I have a table order_executors: id | order_id | user_id | status Where order_id and user_id are external keys. The status columns means the state if row. It accepts 0, 1, 2: 0 - default 1 - accepted 2 - canceled So, I discoverated the violation of…
user15444752
0
votes
1 answer

Which normalization rule does this table violate?

I have a table executors with columns: id(pk) | order_id | executor_id(ek) | execution_price | created_at | selected 1 1 200 1893883332 NULL So, this table contains all available executors and their…
user15444752
0
votes
0 answers

nix-shell script does nothing when using script

I'm quite new to Nix and I'm trying to create a very simple shell.nix script file. Unfortunately I need an old package: mariadb-10.4.21. After reading and searching a bit I found out that version 10.4.17 (would've been nice to have the exact version…
AronNeewart
  • 461
  • 6
  • 18
0
votes
1 answer

MariaDB Check value of an attribute w/ another table attribute

I want to assure at inserting a manager that department manager start date [DEPARTMENT.mgr_start_date] is coming after his birthdate [EMPLOYEE.bdate], how can I do that? CREATE TABLE IF NOT EXISTS EMPLOYEE ( ssn INT(16) unsigned NOT NULL, …
Muhannad Bashar
  • 21
  • 5
0
votes
1 answer

How to setup MySQL users with Maxscale

I'm setting up a 3 nodes (MariaDB 10.4) Galera cluster with 2 frontal servers. Inside each of these frontal servers there is also a Maxscale 6…
CrazyRabbit
  • 251
  • 3
  • 10
1 2 3
…
10 11