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

Why is my MariaDB import only importing some of the rows of data?

I have a 12 GB .sql file that I got from our production server via mysqldump. Our production server and I are both using MariaDB 10.4 (I recently upgraded from MariaDB 5.5). My coworkers (using MariaDB 10.1) are able to import the .sql file just…
Kyle Challis
  • 981
  • 2
  • 12
  • 28
0
votes
1 answer

Laravel and CTE's

I'm trying to convert the following SQL query into Laravel code using taudenmeirs' laravel-cte package. WITH `cte` AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY channel_id ORDER BY created_at DESC) AS row_number FROM…
Mark D
  • 327
  • 1
  • 9
  • 15
0
votes
0 answers

Return an extra column based on the results of a subquery

I have two tables, one with deals and one with companies. In the table with companies I have lat's and lng's. With a subquery I am able to get the deals, the companies and the distances between the deals and one specific location. But I want a…
Timo de Vent
  • 1
  • 2
-1
votes
0 answers

MySql 1052 error began happening at version upgrade

I have a MySql view defined basically in this way CREATE VIEW viewexample AS SELECT CONCAT(a.ID,d.ID) as ID FROM`TBLA` a INNER JOIN `TBLD` d ON ... group by a.ID,d.ID It is working perfectly in a MySql 5.6.21 server, I can perform select * from…
Lucas
  • 1
  • 3
-1
votes
1 answer

internal storage type of ENUM and SET changed in tables created with >= InnoDB-4.1.12

Can anyone help on how to handle this scenario . I am trying to make a relationship between two tables. CREATE TABLE `saccos` ( `id` bigint(20) UNSIGNED NOT NULL, `saccosName` bigint(20) NOT NULL, ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4…
Gabriel Rogath
  • 710
  • 2
  • 8
  • 23
-1
votes
1 answer

MariaDB server version for the right syntax to use near 'FOR CHANNEL 'master1_test116'' at line 1

MariaDB [(none)]> CHANGE MASTER TO MASTER_HOST='192.168.56.116', MASTER_PORT=3306, MASTER_USER='replica1', MASTER_PASSWORD='pass@123', MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=327 FOR CHANNEL 'master1_test116'; ERROR 1064 (42000): You…
Manish
  • 1
-1
votes
1 answer

case statement which taken match of same status in mysql

I have 2 tables, One table has status and another one table has mark and id. table1 id versin name 1 0 ram 2 1 ram 3 2 ram 4 3 ram table2 sid status name 1 Pass ram 2 Pass ram 3 Pass ram 4 Fail ram this is my…
Vijay
  • 1
-1
votes
1 answer

mysql decimal() Numeric value out of range: 1264

I have a silly problem with decimal and mysql. Mysql version is: "10.4.19-MariaDB - Source distribution". I cannot understand the right setting for this column datatype. I would like to store and then display a number like this one: 325,130. So i…
P.Davide
  • 377
  • 2
  • 6
  • 19
-1
votes
1 answer

Count unique integer value between multiple overlapping ranges saved in mysql table + PHP

We have a situation to get unique count between saved range of mysql table. lets say, I have data saved in table like below: sr_no start_sr_no end_sr_number total_count 1 1 10 10 2 5 15 11 3 27 35 9 4 11 21 11 now see in above…
Rakesh Verma
  • 1
-1
votes
1 answer

How split multiples subvalues with multiples SubIndex in columns mysql?

CREATE TABLE tablename (id INT,C1 text); INSERT INTO tablename VALUES (1, '[AU 1] string 1; [AU 2] string 2; [AU 3] string 3.1; string 3.2; [AU 4] string 4.1; string 4.2; [AU 5] string 5'), (2, '[AU 1; AU 2] string 1'), (3, '[AU 1] string 1; [AU 2]…
cnauber
  • 443
  • 5
  • 10
-1
votes
1 answer

MariaDB query for parent and child category

I have this MariaDB table "categories": id category parent_id 1 electronics 0 2 fashion 0 3 TV 1 4 mobile 1 5 Sony 3 6 power bank 1 7 iphone 4 and I want result using…
Durairaj
  • 62
  • 1
  • 9
-1
votes
1 answer

Show first and last mysql record in group with other attributes

I would like to ask for help to display some information regarding queries made in a database. I have a table called membervalues. In this table, I have 4 fields => (id, memberid, submit_datetime, value). I want to show maximum and minimum value of…
user15179042
-1
votes
1 answer

MariaDB 10.4 QUERY or Sub-query Optimization

is there a way to optimize this kind of query. See the given below. Select KPI.*, (select sum(NP_2g_crfs) from kpi_table where date_upload = '14/01/2020') as num_sum, (select sum(NP_2g_den) from kpi_table t1 where t1.id >= kpi_table .id)…
Darius Paul Bacate
  • 1
  • 4
-1
votes
2 answers

How To Display Value by Max Date / Last Date of Year

I need a query to display a value (saldo) following max date / the last date of year, but I have tried but it and it's always showing a value from the first date. Here is my query: SELECT saldo, MAX(tgl_lap) FROM laporan GROUP BY…
FF.Dantiano
  • 71
  • 7
-1
votes
2 answers

how to group two specific items together

I have a database with questions with columns Question, Answer, Type. Currently, this is the sql statement I am running: SELECT Question, Answer, Type FROM goodquestions ORDER BY RAND() LIMIT 0,20 As you can see, I select random values from the…
user13930378
1 2 3
…
10
11