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

How to get the row data that include max value in MySQL?

How to get the total row data that has max(reg_count). When I try this, it gives me only max reg_count value. I want to get the whole row data that has max reg_count in every albumID.(So like this: 4 Bemisal ha 1 1 8) - total 4 rows SELECT albumID,…
Jin youcheng
  • 96
  • 2
  • 9
-1
votes
1 answer

How i can solve this problem "systemctl start mariadb"

I am facing this error root@localhost:~# systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. root@localhost:~#…
VINIT KUMAR
  • 1
  • 4
-1
votes
1 answer

MariaDB Trigger joining two tables?

If you have two tables (course and teacher) table course contains: C#, course_name, teacher, supervisor table teacher contains:T#, teacher_name, department Teacher and supervisor are foreign keys meaning they contain T#. Now i want to make…
Yulaw16
  • 3
  • 2
-2
votes
2 answers

Time between two dates

I want to calculate time in minutes between two dates while only including the time between 08:00:00 and 16:30:00, also excluding Saturdays and Sundays. How can I achieve that? The following is my code which is just calculating time between two…
lgTakunda
  • 49
  • 7
-3
votes
1 answer

Export Mysql with gzip commands to properly create a compressed file & import in AWS

Export with gzip commands to properly create a compressed file of a MySQL database & import to AWS RDS Server
stalinrajindian
  • 1,363
  • 1
  • 14
  • 22
-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
…
10
11