I cant connect java to MariaDB .I saw all similar questions answers but none has solved my problem. Here is my code : /** To change this license header, choose
According to MariaDB's website, you can simply replace MySQL with MariaDB. Great, I thought, however after installing MariaDB (10.5.7), some of my InnoDB tables
I want to create a database trigger that deletes automatically rows where the value of happened_at field is older than 15 days. My table rows id int(11) site_id
I am trying to install Mariadb on Debian but I am getting the error below when I try to install it. Mariadb was actually working for me for a while. I just tr
I'm using Fedora 29. I'm try to run mariadb.service with command:systemctl start mariadb, and give error:Failed to start mariadb.service: Unit mariadb.service n
I have the query below and it gives me a count of 32,000. SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationsh
I have question need to query from product table and have many variants and prices, how can I show like below product. variants. price ========================
I'm attempting to create an SQL query that retrieves the total_cost for every row in a table. Alongside that, I also need to collect the most dominant value for
I have one table that contains two columns: id (integer) list_colum (longtext) - contains json array (e.g. [1, 2, 3]) I want to select all records that have an
I tried out Docker with UFW and i read a lot of this. My goal was to connect to an mariadb database on the host machine from an docker image. Host (running u
I am using MariaDB version 10.2 I have an array of GUIDs stored as JSON in a table and I want to select rows from another table where the ID matches any of the
I have two only records in a database table and I want to delete only one of them. The problem is that I don't have any primary key nor unique identifier, so ho
How do i bulk insert multiple records in 1 query so my db will be efficient I want to create Office and insert multiple new equipments into that office. Table/m
I have a MariaDB (mysql) database with a table which looks like this: MariaDB [DevicesPool]> show columns from Dirs_and_Names; +-----------------+-------
I have the following query which works fine: select a.dataId, a.my_no, b.my_attribute from myDB.table_a a left join myDB.table_b b on a.my_no = b.my_no orde
I have a table having a JSON datatype column which contains JSON array consisting of IDs for another table. I want to return matching rows from that other table
mariadb.service took forever to start. it stuck at activating ● mariadb.service - MariaDB 10.3.31 database server Loaded: loaded (/lib/systemd/system
I'm using phpmyadmin with xampp on both of my home and work machines. Some queries didn't work for me when I was working on one computer, but it worked on anot
My model: class Course(models.Model): language = models.ForeignKey(Language) name = models.CharField(max_length=50, unique=True, default='course')
I tried to install the Mariadb plugin for python. Therefore I downloaded the MariaDB Connector and installed it and then I installed via pip3 the mariadb. And I