I am working with a NBA script in MySQL and I have to find out who is the shortest player in database. I am using feet as measurement and after executing the query i found out that the player the…
I have a query below that retrieves groups from the database; it works fine except when I run it through pest php test case and hit the controller; the test fails and says IlluminateDatabaseQueryException: SQLSTATE[HY000]: General error: 1 no such…
I need to set up my connection with PowerBI to Azure Database for MySQL flexible server. I can't seem to find any reliable documentation to do this. Initially I'm getting this error when I try to connect to the server.…
I have the following query where I am adding three new columns by using the addSelect function DB::connection('mysql_slave') ->table('applications') ->whereNull('applications.deleted_at') ->when($column != 'contract_return_date' && $column != 'contract_delivery_date',function ($query) use ($column,$date_from,$date_to){ return $query->whereBetween('applications.'.$column, [$date_from, $date_to]); }) ->join('customers','applications.customer_id','=','customers.id') ->join('departments','applications.department_id','=','departments.id') ->select([ 'applications.id', 'applications.customer_id',…
I have a table that listed six unique numbers in a row, on their specified columns: id n1 n2 n3 n4 n5 n6 1 44 11 32 14 28 19 How I can use MySQL to get the row values…
I'm having great difficulty writing this query and cannot find any answers online which could be applied to my problem. I have a couple of tables which looks similar to the below with. Each purchase date corresponds with an item…
I'm using laravel sail to launch a statamic website on my local machine (macOS). All packages are up-to-date and launch correctly however, the mysql service starts, then fails due to "another process with pid 62 is using unix socket file.".…
I have a SQL databases of users forms, and want to set up some routine or maybe even PHP that will automatically delete empty rows which looks like this: Column1=(Name=John Surname=Doe) | Column2=(Name=John Surname=) | Column3=(Name=John Surname=Doe) In this case…
I try few mysql statement but didn't come to my expectations. How to get the total of to_user chat and order by the lowest total? Let say in this case, id 7 chat with 2 user id 6 chat with…
I am starting to learn SQL and I had a question. I am running the following query: SELECT ProductName FROM Products WHERE ProductID =ALL ( SELECT ProductID FROM OrderDetails WHERE Quantity < 0 ) order by ProductID; Why does this…