I have stored about 7 million biological protein sequences in text field of MySQL table (using InnoDB storage engine and latin1_swedish_ci collation). Sequence
I have two tables: The first one contains numeral values, it looks like this: The id column is the primary key; it has the attribute AUTO_INCREMENT. All col
I got this message when I try to run query on XAMPP in macOS #1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, n
I want to create UserRole table, but mariaDB complains with the following error: Error Code: 1005. Can't create table `testdb`.`userrole` (errno: 150 "Foreign k
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