On one system I have MariaDB installed via Homebrew and I can manipulate its DBs with Beekeeper Studio. Setting up a new system in what (as far as I can remember) is the same way, I find that no applications…
I have this query which selects the users for a given branch. SELECT u.first, u.last, u.id, (SELECT u1.user_type FROM users_branches AS u1 WHERE u.id = u1.user_id AND u1.branch_id = @foo LIMIT 1) FROM users AS u WHERE EXISTS (SELECT 1…
I have a PHP/MariaDB application that has some images stored as BLOBs. I recently moved the app to a cloud hosted service and the behaviour of viewing images is broken. PHP serving a GET request for an image is this:…
I have 2 tables and I like to get sum of values and also to group by the result. I have this query: SELECT SUM(tr_amount) as total, projects.pr_type from transactions INNER JOIN projects ON projects.pr_name = transactions.tr_pr_name WHERE tr_amount <…
This query works as intended in MySQL, but fails in MariaDB as not being able to recognize the "uID" field. Why? Is it possible to code one version for both? select user_id as uID, last_name, first_name, athlete, parent, coach, code,…
I have a list of products, and a list of related products. I know I can retrieve the list of products, then retrieve the list of related products, using two SQL queries. But I need to return the list of…
I want replace in a column a string of characters with UTF8 characters, using REGEXP_REPLACE and/or REPLACE. $search = mysqli_real_escape_string($id_mysql, $_POST['search']); $new = mysqli_real_escape_string($id_mysql, $_POST['new']); mysqli_query ($id_mysql, "UPDATE table_name SET column_name = REGEXP_REPLACE(column_name, '$search', '$new') WHERE column_name REGEXP '$search'" )…
i need to select only full hour values from a list of datetime entries. But if i select more columns, the group by hour doesn't work. So if i don't select the column "datetime" the group by works. SELECT datetime,…
There is the following code in my docker-compose.yml mariadb: image: mariadb:10.8.2 restart: always environment: MARIADB_ROOT_PASSWORD: test MARIADB_DATABASE: mydb ports: - "3306:3306" container_name: mariadb networks: - my-network then I used the following command to start a Docker container docker stop mariadb…
My requirement is to get ID of a row where date_created is max for which I have written below query. But everytime I run it its returning wrong ID. In this post select returns wrong id when using max people…