I have a simple database with the user and the country tables. Which user belongs to only one country. Which country has a list of users. Right now Im using group_concat (code below) and its working in a "manual" way…
I am trying to set up Laravel 11 on Windows 11. I am using WAMPServer for Apache/PHP/MySql. I have installed the installer globally using Composer. I then run this command to create a Laravel project: laravel new example-app However, when…
I have a large number of similar but unique update statements, where the same fields are being updated with different values, ie. UPDATE tbl SET field1 = "x" WHERE pk = 1; UPDATE tbl SET field1 = "y" WHERE pk…
My stack is win10/wsl2/ubuntu/docker desktop. I'm stuck on running a MySQL docker container. This is a part of my docker-compose.yml: mysql: hostname: a-mysql container_name: a-mysql image: mysql:8 restart: unless-stopped volumes: - ./mysql_data:/var/lib/mysql - ./mysql/my.cnf:/etc/mysql/conf.d/my.cnf - ./mysql/dump:/docker-entrypoint-initdb.d env_file: - .env ports:…
I have a mysql table that looks like this: table1 User_ID | Serial | Warranty 1 | 12 | 2024-01-01 4 | 13423 | 2022-11-21 1 | 643r | 2026-05-13 4 | r42r4 | 2023-10-07 5 | 743f | 2026-06-22…
I'm trying to insert a row in a MySQL 8 table that has a column of type BINARY(16). In detail, I'm using Spring JdbcTemplate, and the information is stored in a Java UUID object. I can't find how to do…
I'm trying to install this 4chan clone: https://github.com/Ro0ul/4Chan-Clone I'm executing one of the queries on the sql folder on phpmyadmin: CREATE TABLE comment( id INT AUTO_INCREMENT, title VARCHAR(255) NOT NULL, body TEXT NOT NULL, post_id INT NOT NULL, posted_at DATETIME…
I have a table in MySQL 8 called "temperature" with the fields IDDevice, Data, Temperature. I need to analyze each device and return a list of temperatures that have been out of the range 2-8 degrees in a 20 minutes…
I have 3 tables in a MySQL database user user_id, (PK) email agreement_user agreement_user_id, (PK) user_id, (FK user.user_id) details contract contract_id, (PK) agreement_user_id, (FK agreement_user.agreement_user_id) details What should be the query to get contract.details and user.email given a contract_id
I am using mariadb to store a large number of measurements. A common query I do selects for a data range. It takes a little long, something like 10 to 20 seconds, and it gets worse and worse, so I…