Laravel – query all models that are not between two dates
I have a car model and an order model, i need a query that will filter the list of cars that are not rented between two dates, i'm lacking the logic to get the answer right what i came up…
Mysql – Gaps and islands problem to get minimum for each partition, given date continuity of 1 day
I have many records in the table. I was grouped by continuous date. example : begin_at (From Date) end_at (to date) 2023-05-05 00:00:00 2023-06-18 00:00:00 2023-06-11 00:00:00 2023-06-18 00:00:00 2023-06-12 00:00:00 2023-06-18 00:00:00 2023-06-13 00:00:00 2023-06-18 00:00:00 2023-06-14 00:00:00 2023-06-18…
Mysql – How to optimize this sql query on + 2 million rows
I have a Sql database with +2 million rows and growing fast. There aren't many columns, only code, price, date and stationID. The aim is to get the latest price by code and stationID. The query works well, but takes…
What do "near "CASCADE"" and "near "CONSTRAINTS" error mean in MySQL?
I apologise for the incorrect use of sql terms, I'm still a novice. So, I produced a ddl script from a relational model, converted it to MySQL and tried to "run" (the app Im' running it at is called phpMyAdmin)…
WordPress – How to make a condition in php – display one or another date?
How to make a condition in this construction - display one or another date? <?php foreach ($items as $k => $v): ?> <tr> <td><?= $v['number'] ?></td> <td><?= $v['date_from'] ?></td> <td><?= $v['date_till'] ?></td> <td><?= $v['dealer_title'] ?></td> <td><?= $v['producer_title'] ?><?= $v['sys_create'] ?></td>…
Springboot+MySQL table return empty
I'm a new to java and trying to connect mysql database using springboot. But the data returned from the database.table is empty. Below is my code, where is the problem? There is no error code, which means that there is…
Mysql – Sum by month cumulatively, 2 variables
I have two columns: wash score (wash_sc) and agric score (agric_sc). I want to sum both cumulatively and group by month. Currently am able to accomplish this for one variable, though it is takes a long time to return the…
Mysql – Group Report With Header and Detail?
I have table transactions with below details id dt_trans category description amount 1 2022-08-05 Expense Food 60.00 2 2022-08-05 Travel Petrol 20.00 2 2022-08-08 Travel Petrol 20.00 then I want to create report based on below report dt_trans category description…
Laravel mysql order by with wherehas
I have 2 tables :- users - id,name,email, mobile user_info - id,user_id, store_name, startup_date User Model class EloquentUser extends Model { protected $table = 'users'; /** * The attributes that are mass assignable. * * @var array */ protected $fillable…
Laravel – Custom primary key value not being displayed correctly
Hi hope you are having a good day ! ,I have a Laravel application where I'm using a custom primary key for my Ticket model. In the store method of my TicketController, I generate a random string for the ticketID…