Note: It was working on single view page, but once I pass it to User Dashboard it will be showing error. I was trying to pass user data from database to form table but it was showing error Here's my…
I have used the following Raw query in my Laravel project. $statisticsInRangeDate = $myModel->selectRaw( "floor(datediff(created_at, '{$dateInfo['currentRangeDate']}')". " / {$dateInfo['daysRange']}) * {$dateInfo['daysRange']} AS diff_days_range, count(*) as total_clicks, ". 'min(created_at) ,max(created_at)' ) ->groupByRaw('diff_days_range') ->orderByRaw('diff_days_range DESC') ->get(); The raw query is: select floor(datediff(created_at,…
I am using using MySQL (InnoDB engine). I am running SQL query with WHERE IN statement which is also ordered. I decided to create the perfect index, so my query will not run slow. Surprisingly, after creating the perfect index…
I have this table in my database. I want to get the index of column which value equal 1 use select. If have many one in one row,I want to get first index. For example,1 for the first row,2 for…
I want to add a date column to an existing table. I only want to add the last date of the month (e.g.30 Apr 2023). How do I do this for all the row? Is this possible? Date BLa Bla…
i need join another table by two field like this,how to get this by squelize SELECT * FROM Issue LEFT OUTER JOIN File1 ON File1.project_id = Issue.project_id AND File1.file_path = Issue.file_path WHERE Issue.project_id = 1 AND version_id =1 so I…
I have two queries, A and B. Query B can run only if i get the result from query A. But now i do both query separately. Below is my queries: Query A SELECT id, u_name, u_email, u_factory_id FROM wla_user…
I'm trying to run my spring boot application on docker with mysql. Everything is working fine, MySQL DB starts successfully and after that spring application is deployed in container and I end up getting this error : Caused by: com.mysql.cj.exceptions.CJCommunicationsException:…
I want to use group_concate in my queries. I have two tables which are wla_user and wla_factory. In table wla_user, the column factory_id contains 1,8, while at wla_factory, id 1= factory 1 while id 8 = factory 8. While during…
Our Table currently looks like this: Record ID | Name | ... | Value_2301 | Value_2302 | Value_2303| ... Where 2301, 2302 and 2303 are dates in YY-MM format. Due to the nature of our system, as the years go…