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…
Mysql – Products with different prices and sizes
I find myself designing a database for a system for registering orders for a pizzeria. I have a table called "products" that contains these attributes: | PRODUCTS | | --------------------- | | id | int | | name | varchar…
Mysql – How can I pick same time of day across multiple days?
Column utc time created is a datetime field of when entry was made in a table that's updated hourly. Contains 24 entries for each day. I want to query for same time of day across a set of days (might…
Mysql – Pagination is not Working with custom method in SpringBoot
When I was fetching the data only it was working properly, but now I want to apply pagination its not working don't know why? I have tried running query in mysql and there it is working but here not working.…
Add/Subtract minutes from timestamp based on arithmetic sign mentioned in another table – MySQL
I have a table "offset_table" which have only 1 column "offset_in_minutes" (nvarchar(5)). I will store only 1 value in offset_table. Example 1 : "+300" - This means that query should add 300 minutes to timestamp. Example 2 : "-30" -…