Trying to get away from using Sail, and want to make my application without Sail. So far I can't get mysql server to start running. I've tried changing the env DB_HOST to the name of the db in the docker-compose,…
My question is that how many times will COUNT(*) be called for each group? Three times or just one time? If the answer is three times, how can i optimize it. SELECT COUNT(*) AS num1, COUNT(*) / 10 AS num2,…
I have mutation table that stores transactions: M_Date Item_ID Qty 2024-01-02 B-0001 4 2024-01-03 B-0001 2 2024-01-03 B-0001 -1 2024-01-04 B-0001 -2 2024-01-03 B-0002 5 2024-01-03 B-0002 -2 2024-01-04 B-0002 1 2024-01-06 B-0002 -2 the scenario is; I select begin…
I have an application that runs on PHP 5.6 and Laravel 5.2. It's hosted in AWS on an AWS Linux 1 EC2 machine. This web server connects to a RDS MySQL instance. The RDS instance has been running MySQL 5.7…
I have a script which runs for long hours say like 10-15 hours. The script performs well thorughout the process but there is a mysql table creation query in the script where PHP throws warning "PHP Warning: Error while sending…
I have an issue between two tables in sql Table 1 name_id 1 2 3 SPEC-A 100 110 120 SPEC-B 200 220 230 Table 2 name name_id cat M.John SPEC-B 2 J.Smith SPEC-A 3 So I would like to connect…
I need to fetch the string For reference 110_112_120_122_130_132_140_143_149_151_154_160_162_165_171_173_194_215_236_257_278_299 use this as a subjects I am using the below query select * from table_name where subjects like '%_21_%' ; which is not showing desired result. Note - 21 can come…
Mysql 8 takes 2 minutes to sort an empty set The following table on 8.0.33 MySQL Community Server CREATE TABLE `eventiAcc` ( `chiave` int NOT NULL AUTO_INCREMENT, `tipo` tinyint NOT NULL, `account` int DEFAULT NULL, `utente` int DEFAULT NULL, `timestp`…
The goal is to return an array of available users that are assigned to the site we are working on and are available to do the task we want to assign. For this question, we can assume that we are…
<?php require_once('dbcon.php'); $query = "select * from indexpage"; $query2= "SELECT * FROM `blogintro` ORDER BY `id` DESC;"; $query3= "SELECT * FROM `indexjob` ORDER BY `id` DESC;"; $query4= "SELECT * FROM `dsintro` ORDER BY `id` DESC;"; $result = mysqli_query($con,$query); $result2 =…