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
We are currently moving the DB to another Server but we got a problem. Our Database is quite big and when we want to Import it to our new MariaDB Server with Ph
I'm working with MariaDB. when I try to show some result don't show me nothing. select if(fecha is null,'hello','bye') dat from table I'm trying to
When working with JSON in MariaDB it is possible to index single-point values using virtual columns e.g. ALTER TABLE features ADD feature_street VARCHAR(30) AS
Example data: +----+-------+----------+ | org_id | Name | ParentID | +----+-------+----------+ | 1 | Org1 | 2 | | 2 | Org2 | NULL | | 3 | Org3