MySQL Query to select from table specific rows
I have a table which looks has the following values: product_id custom_id custom_value 1 10 A 1 9 V 2 10 B 3 3 Q I am looking for a mysql query to get all values from product_id once and…
Mysql – How to select max value from the output of another query
I have a table as below: id english hindi maths science 1 80 76 90 79 2 8 63 80 69 3 50 50 80 69 4 80 80 80 69 5 80 50 70 69 I wrote a query…
Mysql – How to simplify a case when *condition* in (select
I have a table that create the relationship between users and groups that looks like: UserGroups group_id user_id 1 1 2 1 1 2 1 3 and the table users looks like: id name 1 John 2 Mary 3 Bob…
How to convert YYYY-MM-DD HH:MM:SS TO HH:MM:SS IN mysql?
i have one column (vedu_time) in "YYYY-MM-DD HH:MM:SS" format, i required new column (ganta_time)(new) having only HH:MM:SS for all my records at a time. Please suggest the query. vedu_time | ganta_time --> New column --------------------|------------ 2021-12-01 07:12:30 | 07:12:30 2021-12-01…
How can use turkish lowercase ı in mysql
In mysql when a user tries to add a char entity with containing uppercase of turkish I it gives an error. I searched for the cause and I learned that turkish I is mixed with lower turkish ı and i…
Mysql – How to insert rows for each item with missing date in between
I have a table as such date, id, value 01/01/2022, 5, 10 05/01/2022, 5, 4 06/01/2022, 5, 10 04/01/2022, 10, 1 09/01/2022, 10, 7 Each id doesn't necessarily have consecutive days of rows starting 01/01/2022. I want to transform my…
calculate with decimal values – PHP
At the the moment, I stored values in my mysql database as a decimal value (199,54). But If I get this value with php (mysql query) and would like to calculate with it: echo ($row->myValue) / 5; I get the…
SQLAlchemy / mysql – How to insert data without calculated (computed) columns
I have a calculated (computed) column in a table and would like to insert rows with the calculated column not specified with SQLAlchemy. However, the SQL query for insert generated by SQLAlchemy includes the calculated column. Is there a way…
how to get data from 19:00:00 pm to 07:00:00 am – Laravel
$star = $request->input('start_date'). ' ' . '19:00:00'; $end = $request->input('end_date'). ' ' . '07:00:00'; $employee_qty_in_shift2 = PatrolGateSurveillanceTransaction::where('type', 1) ->where('client_location_id', $request->client_location_id) ->where('created_at', '>=', $star) ->where('created_at', '<=', $end) ->sum('employee_qty'); dd($employee_qty_in_shift2); The above code cannot filter data from 19:00:00 to 07:00:00 Expected result:…
Mysql – Order index for rows related to another table
I have a table that stores an id from another table, an index for a specific id and some different value user_id index_value some_value 1 0 01 1 1 02 1 2 03 2 0 04 3 0 05 3…