There is a column in a table with dates called 'date_activated'. I would like to add a column and use the information from the 'date_activated' to produce a datetime format that sets to the first day of the year. For…
I don't know how to word the title properly, anyway what I mean is: For example I have this 'transaction' table SELECT ITEM_ID, SUM(QUANTITY) AS IN WHERE TYPE = IN GROUP BY ITEM_ID - SELECT ITEM_ID, SUM(QUANTITY) AS OUT WHERE…
Here is the message I got after the migration. IlluminateDatabaseQueryException SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. (SQL: select * from information_schema.tables where table_schema = econnect and table_name = migrations and table_type =…
I have the following query params in string format $query = '->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'), request('endTime')])'; How do i pass it to the eloquent? Am trying to achieve something like this InboundMessage::query()->{$query}; Am getting the error below Property [->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'),…
I have a table with 30 columns. I want to remove all the rows in the table where a subset of columns have all the values in the row as either 0 or NULL. I know that I can write…
There are 2 tables : Sales & Transaction. I need to update the INDICATOR column of the Sales table using CASE WHEN by joining these two tables. Using below query but not working : Update Sales a set a.indicator= CASE…
how to convert the DateTime column to date? I need something like the select * from sales where date = = "2022-09-18"; I need to get all sales from a specific day I tried this How can I convert datetime…
My code $datas = DB::table('patrol_gate_surveillance_transactions as a') ->leftJoin('client_locations as b','a.client_location_id', 'b.id') ->leftJoin('clients as c', 'b.client_id', 'c.id') ->select('a.client_location_id as location_id', 'b.name as location_name', 'c.name as client_name', DB::raw('SUM(CASE WHEN a.type = 1 THEN employee_qty ELSE 0 END) as e_qty_in'), DB::raw('SUM(CASE WHEN a.type…
I want to create a login page script with the username and password as the data account from db. n then when my input is doesn't match the else didn't execute while username and password is did not exist in…
I installed MySQL on Kali Linux and I enabled it using sudo systemctl enable --now mysql I am afraid since it opens a port that it can be exploited so after finishing I run sudo systemctl disble --now mysql Is…