Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.3]

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL.

MariaDB 10.3 is an open source database server that offers similar functionality compared to MySQL. Since version 10.0 MariaDB has veered off MySQL and now implements a different set of features.

MariaDB 10.3 implements system-versioning tables, PERCENTILE_CONT(), PERCENTILE_DISC(), and MEDIAN() window functions, INTERSECT and EXCEPT clauses, cursors with parameters, LIMIT in multi-table updates, LIMIT in GROUP_CONCAT(), and many other new features.

171 questions
0
votes
2 answers

Generate new ID for every new combination of column 1 and column 2

I would like to generate a new ID number for every new combination of column 1 and column 2. For example: ID | column 1 | column 2 1 | peter | blue 2 | mark | red 1 | peter | blue As there will be new rows added over time, with new…
repjas
  • 1
  • 3
0
votes
0 answers

how to fix ERROR 1044, ERROR 1046 and being unable to change password to users?

I'm already too tired of trying so many different things and I can't even bypass an error which is running. I know some of you might think it's a duplicate question, but I've seen dozens of questions, so I don't think the answer is so simple, nor is…
newbie
  • 1,199
  • 1
  • 10
  • 25
0
votes
1 answer

Hyphen in MATCH AGAINST Fulltext MariaDB

I have DB table PERSON something like below |ID |FIRST_NAME |LAST_NAME| |1 |Peter-Parkar |Williams | |2 |Peter Panatano|Williams | |3 |Peter-Pant |Nati | I want to search and get the first name result using this query SELECT ID,…
Sathya
  • 233
  • 1
  • 4
  • 13
0
votes
2 answers

Can't connect to MySQL using Acumos_mariadb_service docker container

I have installed the maria_db service as a docker component of Acumos. Even if the docker container is running, I am not able to execute the following command: mysql -h localhost -P 3306 --user=root --password=98dceddd-a364-4f76-abe0-b0dc7283fc7f -e…
Shabnam Sultana
  • 1
0
votes
2 answers

MYSQL codes not being read

When I input a code or anything into MySQL and hit "enter" it moves down and "->" appears. It is as if the code is not going through or the code is not being read. I have attempted to download "add-ons" but I am really not sure what I am doing. This…
nicole smith
  • 3
  • 1
0
votes
0 answers

DB optimization

I have problems with my DB proceses I runn an website developed using angular, typescript and laravel Script demo: https://codecanyon.net/item/mtdb-ultimate-movietv-database/6447206 Script documentation:…
ivan
  • 95
  • 3
  • 14
0
votes
1 answer

Hibernate failed to lazily initialize a collection

I set up two datasources in Spring Boot. In a controller I want to persist a couple of parent-child entities on both. They're almost identical bidirectional relationships, but the first one works, while the second emits a committing message but…
4javier
  • 481
  • 2
  • 7
  • 22
0
votes
0 answers

MariaDB Grant wildcard database name

In my MariaDB database, I have created user with wildcard(%) database name with GRANT OPTION permission. When this particular user tries to run a GRANT command to another user over a GRANTED database it gives a ERROR 1044 (42000): Access denied for…
Nissanka
  • 123
  • 1
  • 13
0
votes
0 answers

How to write REGEXP to count the number of times a specific pattern is found in a string in MariaDB 10.3

I would like to rewrite the below Oracle REGEXP_COUNT function into MariaDB 10.3. I am trying to rewrite using LENGTH concept but couldn't get valid result. I am using the…
Raam
  • 39
  • 1
  • 8
0
votes
1 answer

Update multiple fields from subquery

The current query is: update topics set posts = (select count(*) from posts where tid = 27), lastpost = (select max(pid) from posts where tid = 27) where tid = 27; How do I merge the two sub-queries into this for the update query? select count(*),…
XTF
  • 1,091
  • 1
  • 13
  • 31
0
votes
2 answers

where column in from another select results with limit (mysql/mariadb)

when i run this query returns all rows that their id exist in select from table2 SELECT * FROM table1 WHERE id in ( SELECT id FROM table2 where name ='aaa' ) but when i add limit or between to second select : SELECT * FROM table1 WHERE id in…
mmjvox
  • 37
  • 1
  • 7
0
votes
2 answers

MariaDB extract a column for a variable of Type ROW dynamically

delimiter $$ CREATE OR REPLACE PROCEDURE `populate_audit_helper`( IN in_db_name VARCHAR(100), IN in_tbl_name VARCHAR(100), IN in_row_id INT(10) ) BEGIN DROP TEMPORARY TABLE IF EXISTS t_agents; SET @SQL := CONCAT('CREATE…
Vinod Nadar
  • 61
  • 8
0
votes
0 answers

Filter by date from a view does not return all records

I have to make a query on a view filtering results by date bigger than a value. Using the program I noticed that I was not receiving all the results I was expecting. I made some test to try to replicate the issue and I had the same behavior…
Marco
  • 46
  • 2
0
votes
0 answers

how to execute the Mariadb init scripts inside /docker-entrypoint-initdb.d on upgarde

As a part of mariadb instance (Container) upgarde i need to create some new tables. So i have copied the update.sql script in /docker-entrypoint-initdb.d , but when i do the upgrade, this is not getting called. Same thing works when I do a fresh…
Gaurav Mittal
  • 21
  • 4
0
votes
0 answers

MariaDB 10.3 gap of numbering of the sequence

I have a table where id is primary key and squence. In transaction I call sequence select NEXTVAL(next_cons_id) as next_cons_id then create a new record where field id = next_cons_id got from code bellow. DDL sequence CREATE SEQUENCE IF NOT EXISTS…
gregman
  • 332
  • 1
  • 11
1 2 3
…
11 12