Extracting year and total days between range of date – SQL – Mysql
I have data with start date and end date (Say 20th Feb 2018 to 20th Feb 2020), I want to find out the total days in every year inside this range. For example: 2018 - x days , 2019 -…
Maintain multiple row data in single row mysql
There is my table look like id name deduction amount 01 teat Home Rent 1000 01 test GPF 500 i want show my data in deduction report like below table id name home_rent gpf 01 teat 1000 500 mysql code…
How to calculate the retention rates of my customers? – Mysql
I'm currently trying to calculate the retention rates of my users, and I am having difficulties to get what I need. What I want to do is for any given date be able to calculate all the new registered users…
MySQL – Best methods to provide fast Dynamic filter support for large-scale database record lists?
I am curious what techniques Database Developers and Architects use to create dynamic filter data response Stored Procedures (or Functions) for large-scale databases. For example, let's take a database with millions of people in it, and we want to provide…
Trouble creating parent-child relationship between two database tables using php codeigniter – Mysql
I have two databases tables called article_category and article_case. They are supposed to be combined in a webpage as below: Article category[title] Article category[description] Article case[title] Article case[contents] Article case[title] Article case[contents] This should repeat itself using foreach until all…
MySQL using results of a query that has distinct counts in another query
I hope someone can help with this! I've used the following query to count the distinct values in column2 and column3 and filter the results: SELECT column1, COUNT(DISTINCT(column2)), COUNT(DISTINCT(column3)) FROM table1 GROUP BY column1 HAVING COUNT(DISTINCT(column2)) > 1 OR COUNT(DISTINCT(column3))…
How to insert Geo location using spring data JPA – Mysql
I am trying to insert Geo location into MySql database using spring data JPA. MySql Version : 5.7.17 For spring boot I have used 2.5.6 boot version and below dependency I have used <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId>…
table i created is not showing in SSMS even after refreshing – Mysql
i saved a table in my SSMS database but its not showing even after i refresh it. any idea what should be done??
MySql.EntityFrameworkCore generating invalid SQL syntax on SaveChanges
I am trying to use .NET 7 and EntityFramework with MySQL. I am using MySql.EntityFrameworkCore v7.0.0 installed via NUGET. I am able to scaffold my context and entities ("reverse engineer / db first"). Also I can successfully use the generated…
MySQL – Getting number of days user spent on each status
I have been trying to extract the number of days a particular user spent on each status in a month from the MySQL database table. The data is saved in log format which makes it a bit hard to work…