Questions tagged [mariadb-10.5]
100 questions
0
votes
0 answers
LOAD DATA INFILE the entire file into a field
I am storing the contents of text files in a table
CREATE TABLE Pages
(
ID int(11) unsigned NOT NULL,
Text mediumtext COMPRESSED,
PRIMARY KEY(ID)
) ENGINE=ARIA DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ROW_FORMAT=DYNAMIC
I try to INSERT each…
Googlebot
- 15,159
- 44
- 133
- 229
0
votes
0 answers
Mariadb Engine-Independent Table Statistics migration upgrade 10.3 to 10.5
We upgrade MariaDB version from 10.3 to 10.5. Some explain plans change for worst plans.
We see that documentation https://mariadb.com/kb/en/engine-independent-table-statistics/ and we see that
use_stat_tables='preferably_for_queries'
is default…
Mr_Thorynque
- 1,749
- 1
- 20
- 31
0
votes
1 answer
How to bring results from rows into columns with respective values in SQL
I currently have the below results table:
Company ID
External ID
Attribute
Int Value
1
101
Calls
3
1
101
Emails
14
1
101
Accounts
4
2
102
Calls
2
2
102
Emails
17
2
102
Accounts
5
And I would like to transform my query results…
Kimberley
- 23
- 5
0
votes
0 answers
How to use @SequenceGenerator annotation through eclipselink to get the sequence next/last value from Maria db database sequence object
The below code for Java works fine in Oracle-eclipselink-java, as we migrated the same to mariadb, we are facing the issue stated below.
Db sequence:
CREATE OR REPLACE SEQUENCE `com_seq` start with 370700 minvalue 1 maxvalue
9223372036854775806…
Arun
- 1
0
votes
0 answers
MariaDB - How to find the non english characters/words
Here we have the "name" column and values are
"Kumaran",
"Poziom insuliny",
"surowicy",
"Alphabets".
The above values "Poziom insuliny",
"surowicy" - are not an english words.
Can you tell me how to find those words in mariaDB.
Thanks in Advance
0
votes
1 answer
MariaDB shows errors instead of warnings since update 10.1 to 10.5
System 1 and System 2 have been identical. Since updating the System 1, MariaDB throws errors in system 1 (no default, string instead of int) which have been warnings before.
No settings were changed manually.
Are there settings which potentially…
til
- 832
- 11
- 27
0
votes
0 answers
Subquery returns more than 1 row nested concat error
Subquery returns more than 1 row on this SQL statement:
UPDATE bar
SET bar.bar_id = CONCAT(CONCAT(
(select
west.west_id
from west
where bar.west_id = west.id),
':'), (select bar.number from bar))
I want to update the…
TechJunkie
- 1
- 1
0
votes
1 answer
Docker and Mariadb 10.5: Can't set root password
This is my docker-compose.yml file:
version: "3.9"
services:
db:
image: mariadb:10.5
restart: always
environment:
MARIADB_ROOT_PASSWORD: "mypassword"
MARIADB_DATABASE: "mydb"
MARIADB_USER: "myuser"
…
Philipp S.
- 827
- 17
- 41
0
votes
1 answer
Importing mysql5.8 dump into mariadb 10.5 does not let me use already created users
I've a very fresh installation of mariadb-server-10.5 (1:10.5.15-0+deb11u1) on a freshly installed debian 11.1 .
On the old machine with mysql-server (5.5.9999+default) and debian 9.6 I created a dump like this:
mysqldump -u root -pSOMEPW…
user2194805
- 1,201
- 1
- 17
- 35
0
votes
0 answers
mysql - WSREP state transfer ongoing
I'm using Galera for clustring. My OS is ubuntu.
I have 3 nodes:
*.30
*.31
*.32
#systemctl status mysql
mariadb.service - MariaDB 10.5.16 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
…
S.M_Emamian
- 17,005
- 37
- 135
- 254
0
votes
0 answers
Wrong Time and Date with MariaDB mysql
I've got a problem with my mariadb the time and data are not correct i've set the Timezone that I wanted but there is no changes:
The wrong date and time
enter image description here
The correct date and time
enter image description here
Chris FERREIRA
- 9
- 1
0
votes
0 answers
Prevent Update Trigger From Firing After Insert Trigger?
I have a MariaDB 10.5 database with a BEFORE UPDATE trigger that is getting triggered after a BEFORE INSERT trigger which is causing problems for me.
Is there a way I can prevent the BEFORE UPDATE trigger from triggering after the BEFORE INSERT…
Abdelfattah Radwan
- 431
- 8
- 20
0
votes
1 answer
MariaDB upgrade from 10.5 to 10.6: mysqli::real_connect(): (HY000/2002): No such file or directory
I have a MariaDB 10.5 instance running on a OpenSUSE Leap 15.3 server (PHP 7.4.6).
I'm not able to follow the official upgrade documentation for the installation was made through official SLE repositories (last available version still being 10.5)…
wiltomap
- 3,933
- 8
- 37
- 54
0
votes
0 answers
dumping sql result not properly reference
by the way : its about last years ago, i didnt have the device now , i do backup but didnt test because usually its work as well. if i remember that i use tools heidsql on kali linux.
these code on line 40
KEY `FK_catalogue_kategori`…
Yogi Arif Widodo
- 563
- 6
- 22
0
votes
1 answer
MySQL Fix Gap in Ordinal Sequence
all. I'm working on an assignment to update the order images appear in a table. This is done with a table structure that looks like: product_key, image_key, image_order. The first two are foreign keys to other tables and the latter is an ordinal…
Vann.the.Red
- 1
- 3