My head is about to explode.. For some reason mysql doesn't want to return all rows from a UNION statement. If I use SELECT `full_address` FROM `x_servers` WHERE `service_type` IN ('boost','testboost') It returns 51 rows, while if I use (SELECT…
In our website, we have textbox to ask input values from user. If user input the data Q54497899, rest of the results must be shown from database. Rightnow, I want to add checkbox on each result. I tried to add…
I'm starting mysql server using docker-compose here is my docker-compose.yml file: version: "3.9" services: mysqldb: image: mysql:8.0 container_name: mysqlcontainer command: --default-authentication-plugin=mysql_native_password restart: unless-stopped volumes: - ./db/init.sql:/docker-entrypoint-initdb.d/0_init.sql - C:/Users/crisp/OneDrive/Desktop/html/database:/var/lib/mysql ports: - 8080:3306 expose: - 8080 environment: MYSQL_DATABASE: todos MYSQL_USER: admin MYSQL_PASSWORD:…
I have a project with a mysql database in a container. I use docker-compose to set my project up. And I want to run the mysql command to inspect te database. So I did, and get: docker-compose run --rm database…
I am trying to setup a local server in Ubuntu om Windows with WSL2. I am not a Linux expert by any measure and don't know exactly what I am doing. Sorry for the long post but I have tried…
I want to edit the data held in a view on MySQL. I hadn't realised you could do this but according to this some views are editable. https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html I've just checked the INFORMATION_SCHEMA.VIEWS table and the IS_UPDATEABLE flag is set…
I have discovered that the reason I am getting weirdness with my strings being written to MySQL (5.6) from Kotlin is that, occasionally, they are being double encoded. I've verified this by printing the hex() of the column of two…
My Ubuntu 22.04 server is suddenly telling me that "The redo log file "./#innodb_redo/#ib_redo0 size 23289856 is not a multiple of innodb_page_size." My innodb_page_size is 16K, so the error is correct, but I can't seem to find any advice on…
I am working on spring boot application. I want to dockerize my spring boot application but while I'm trying to make jar file from eclipse I get error java.net.UnknownHostException. I'm a new guy in docker technology. Here is a docker…
I discovered that the dev team on my project (Laravel 7) writes a database query that takes a long time to return results, I monitor mysql_slow.log and the other controller generates the following query: select `id`, `name`, `slug`, `source_id`, `status`,…