Mysql – Select events of upcoming weekend
My table has events with start and end dates. I need to select only the events for the coming weekend. For events of the upcoming week I can just use as it's just the same as the selection for today.…
Issue running XAMPP MySQL without Administrator permission – Port 3306 not showing and Access Denied on localhost/phpmyadmin
I'm encountering an issue while trying to run XAMPP's MySQL without Administrator permission on Windows. When attempting to start MySQL, the port 3306 doesn't show up, and when I navigate to localhost/phpmyadmin, I receive an "Access Denied" error. I've already…
Flatten JSON object in MYSQL
I have a table with 1 column and rows like - Row- {'category': ['mobiles'], 'specs': ['4g', '2gb ram']} Row- {'category': ['computer'], 'specs': ['2gb ram']} I want to flatten the data into 2 columns- category, mobiles specs, 4g specs, 2gb ram…
Mysql – SQL to query a table only if the table contains data
This query below is running but I would like to add this extra condition; run this query only if there is data in the table STAGE.LAB.DATA. I tried CASE and IF THEN, but I can't get it to work. Please…
Runnig a mysql query using ajax or sendBeacon from window.onbeforeunload
I need to run a query when the page is closed by the user. Apparently; window.onbeforeunload us the correct event. In fact I can see that it triggers. Now, the problem is that for some reason (unknown to me) when…
Mysql – get next date record from table
I have attendance table like this: Employee Date_Time Status std001 2024-02-01 22:01:00 IN std001 2024-02-02 06:00:05 OUT std001 2024-02-03 07:59:00 IN std001 2024-02-03 17:00:00 OUT std001 2024-02-04 06:00:00 IN std001 2024-02-04 14:00:00 OUT I want to select the table above…
Running one MySQL query based on 2 conditions
I have a table with various columns in it. I want to run a query on this table that is defined by 2 conditions that rely on 2 parameters, When column_a has a value that is non zero, then set…
sub query from same table mysql
I have questions about sub query. I have table: Emp_ID Date_Entry Clock_In Clock_Out E-0001 2024-02-01 2024-02-01 22:01:00 NUll E-0001 2024-02-02 NULL 2024-02-02 06:01:05 E-0001 2024-02-03 2024-02-03 06:01:00 2024-02-03 14:00:20 E-0001 2024-02-04 2024-02-04 08:00:00 2024-02-04 17:01:05 how to query with mysql…
Mysql – SQL Count Distinct Colums and Return all rows
I have table in MySQL and I am trying to filter the data from ColA and count the instances of a result in ColB while still getting all matching rows TABLE Name: CityCityStuff ColA ColB ColC CityA CityB Other Stuff…
Laravel eloquent GROUP BY
I have four tables: supplies, stocks, stock_ins, and stock_outs. In the Stock controller, I want to sum the total stock_out for each supply . For this, I have used the following query: $supplies = Stock::select( 'supplies.name', 'stocks.supply_id', 'stocks.id', 'stocks.stock', 'stock_ins.quantity…