i have problem on using group by and distinct. when using group by, id cant be shown. but if usingn distinct. it will shown all id and product id. i want to use distinct product id and id will shown…
I am trying to use a count(..) to get the count value of matching records from a related table, using Laravel 8 (Eloquent). The idea is simply to count the number of tasks assigned to each user. I already have…
I am trying to use a count(..) to get the count value of matching records from a related table. I'm using MySQL 8. The idea is simply to count the number of tasks assigned to each user. If the user…
I'm implementing forgot password functionality in my NextJS app. I'm generating a temporary token whenever the user clicks on forgot password. Should I store the temporary token in the already existing users table, User table user_id user_name forgotpass_token here only…
I am trying to install mySQL but on the type and networking section said that the port of 3306 is already in use. What can i do? I already have the xampp on my pc! This port is used by…
I have a user table that has multiple records for each user based on each year.. ID | Name | MemberID 1 | Dave | qwe/2022 2 | Sue | asd/2022 2 | Jas | zxc/2022 3 | Dave |…
I'm trying to bring a time series sum grouped by date, week or month, depending on the total number of dates. For instance, if there is up to 30 days, group the sum by date, if there is between 31…
Can someone give me a hand with mapping this scenario? I tried adding a Salary table and reference to the Instructor just to scratch my curiosity, but only the Details table populates the instructor_id column. The Salary table shows null…
Background: I've inherited a Laravel PHP codebase and needed to make some minor changes. I added a page with a button that invokes this method below to create a database on the fly. This works on my machine in dev,…
The Problem To set the scene, I work on a PHP Laravel system that has taken a drupal-style approach where every field is its own MySQL table. Every table has optimum indexing making it very quick to fetch data for…