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

subtraction between two queries with group by

I use MariaDB and have two tables (orders, invoiced_positions) and I need to calculate how many of each item were invoiced and paid for. So I need to count the rows and group by item_name. The problem of this is that some of the items are reopened:…
PeterStrawson
  • 137
  • 6
-1
votes
3 answers

sql SELECT in IF EXISTS

I'm trying to run this : IF EXISTS (SELECT id_commande FROM historique WHERE id_commande = 57 AND device = 70635601) BEGIN SELECT id_commande FROM historique WHERE id_commande = 57 AND device = 70635601 END ELSE BEGIN SELECT…
niaou suzanne
  • 43
  • 1
  • 9
-2
votes
1 answer

1064 error in mariadb 10.3.15 but not on mysql ver 5.5.62

I was hoping someone might be able to point out which part of the mysql query might be causing the syntax error. This query was working on our previous server running mysql 5.5.62 but is now showing an error on mariadb version 10.3.15 SELECT…
Cthulhu
  • 1
  • 3
-3
votes
2 answers

MySQL, get date where row sum = 3

I want to find the 3rd available appointment from a list of appointments. MySql database has rows with RotaType, Date and UnusedSlots as columns I want to do something like $sql3 = "SELECT * FROM `UsageDailyUnusedSlots` WHERE Date >= '$Today' AND…
Henry Aspden
  • 1,863
  • 3
  • 23
  • 45
-4
votes
2 answers

java hibernate mariaDB Column 'field' cannot be null

I am trying to find reason why my problem exists. I have default value set up as 'USER' but hibernate says that this field cannot be null. Error code: *Hibernate: insert into user2 (active, role, user_id) values (?, ?, ?) 2021-08-22 00:40:28.182 …
AZetZ
  • 21
  • 3
-4
votes
2 answers

union of same table in mysql

I have three queries output which is from same table. but have to merge all the 3 to single mysql query actual query: select SKU_VARIANT1_VALCD, SKU_VARIANT1_VALUE_DESC,SKU_VARIANT2_VALCD,…
Benny
  • 432
  • 1
  • 6
  • 21
1 2 3
…
11
12