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
1 answer

mySQLdump version mismatch - but I have the newest of both

I have read all the other similar questions regarding this issue, and the most recent one is 7 years old so none of the version or the links provided have been helpful to me. I am using XAMPP (Control Panel v3.3.0, compiled Apr 6th, 2021) which…
CJRhoads
  • 11
  • 4
0
votes
1 answer

mysql/mariadb stopped unexpectly, the causes?

I have a digital ocean VPS, and today, the mysql service stopped unexpectly, the error is 2022-09-06 14:20:02 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2022-09-06 14:20:02 0 [Note] Event Scheduler: Purging the queue. 0…
Omar Vásquez Sahuanay
  • 1
0
votes
1 answer

can not connect to mariadb server using dbeaver

I have installed and running MariaDB server on a raspberry 4. I am trying to connect with Dbeaver but i am unsuccessful. Hosting db details: Raspbian: GNU/Linux 10 (buster) mariadb: Server version: 10.3.34-MariaDB-0+deb10u1 Raspbian 10 Client…
thermike
  • 1
  • 1
  • 5
0
votes
0 answers

Unable to change mariadb default data directory from /var/lib/mysql?

Unable to change default data directory: form /var/lib/mysql to /mydata/db/mysql SELINUX disbaled Reboot done Configured at mariadb-server.cnf and also other necessary configuration done. [mysqld] datadir =…
Sheikh Wasiu Al Hasib
  • 450
  • 5
  • 18
0
votes
0 answers

Mariadb use database command giving 1049 error

Getting 1049 sqlstate 42000 error when trying to do Use command The database is being shown in show databases command
Vij P
  • 57
  • 5
0
votes
1 answer

Connecting to host mysql database using via sock

I am trying to connect to a mysql database on my host using a docker container (so I can use it in other containers). I would like to do it this way, because I cannot connect to the database from a docker container -> throws Connection refused…
Majksa
  • 26
  • 3
0
votes
0 answers

mariaDB crush and didn't restart

my company develop db crushed unexpectedly and it didn't restart or start now I backup the file in /var/lib/mysql and clone them to my local to try recover it. I lunched the same version of mariaDB by docker the setting I used were…
Champer Wu
  • 1,101
  • 3
  • 13
  • 32
0
votes
1 answer

SQL select 3 bests scores and other data for each user order by scores

May be you can help me. I would like to display an Hall of Fame From my table with rank. But i would like to select about Difficulty choice, 3 bests Score for each Pseudo in limit to 25 rows maximum order by Score desc. And for each, display all…
Yann LEBRUN
  • 1
  • 1
0
votes
1 answer

Modify characters of a string to their ASCII code plus 10, SQL

I am using mariadb 10.3 and I'm trying to create a procedure that modifies all characters of a string, to each CHAR ASCII code, 10 position ahead. I'm having trouble to find any functions to approach this problem, thanks. For example given the…
Jose Navío
  • 11
  • 4
0
votes
0 answers

Not able to import MariaDB dump file to Azure Maria DB

I m getting below error while importing database to Azure Maria DB through MySQl Workbench ERROR 1064 (42000) at line 1746: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax…
zzstar
  • 23
  • 1
  • 5
0
votes
0 answers

MariaDB - Index not used when there is datatype mismatch between columns in join even after cast

I am trying to join two tables where there is a datatype mismatch between the join columns. Index is not getting picked up even after an explicit conversion (or after forcing the index). What could be the reason? create table table_a ( …
Renjith V
  • 21
  • 4
0
votes
1 answer

Virtual column email

How do I get a proper field builded with the data of all names columns + the @sales.es? The following just set all to 0. ALTER TABLE comercial ADD COLUMN email VARCHAR(100) GENERATED ALWAYS AS (nombre+'.'+ surname1 + surname2 +'@sales.es')…
Jose Navío
  • 11
  • 4
0
votes
0 answers

Creating sort index takes a long time

I have an SQL (MariaDB, version: 10.3.22-MariaDB-0+deb10u1): SELECT v.employee_id AS id, REPLACE( FORMAT( COALESCE(( SUM(COALESCE((COALESCE(v.amount, 0) / COALESCE(ash.value, a.standard, 0)), 0)) / …
Boolean_Type
  • 1,146
  • 3
  • 13
  • 40
0
votes
1 answer

how do I use AZ CLI to configure Azure MariaDB to enable 'allow access to Azure services'?

I could use the below to add a vnet rule in Azure MariaDB connection security page. az mariadb server vnet-rule create \ --resource-group xxx \ --server-name xxx-mariaDB \ --name db-to-aks \ --subnet $SUBNET_ID …
sqr
  • 365
  • 2
  • 12
  • 29
0
votes
1 answer

MariaDB 10.3 - Unions casting integers to strings when using null placeholder

We're using Laravel 8 and have recently updated to MariaDB 10.3 from 10.1. I'm noticing an issue now when using unions in certain cases, specifically when using a placeholder select so that the number of columns are equal. The issue is that the…
kenshin9
  • 2,215
  • 4
  • 23
  • 38
1 2 3
…
11 12