Lately, my company have decided to migrate our Spring application to Microsoft's Azure. Azure gave us the possibility to monitor out SQL (MySQL) queries and their runtime using appinsight. Upon investigation of the logs (telemetry logs) we have found that…
I want to get each employees task count in a month and integrate into bar chart,i managed to get total count of tasks based in a month i am confused how to do that user based,let's say i have 10…
Hi have a table that has Owner ID which is a array of users. Below is my tables. Task table ID Task_Name Task_Owner 1 Create 1,3,4 2 Edit 2,1,3 3 Delete 2,1,4 Owner table: ID Owner_Name 1 Mike 2 Ken…
I have a table with name_id, date and col1-col5 with rates. I'm looking for a solution to compare the average of the rates of the latest day with the average of the rates of the day before the latest day.…
I have an sql file containing, say, "INSERT INTO mytable (ID, Date) VALUES (1, datetime.date(2023, 2, 22));" How do I create a table that will accept this? More explicitly, in "CREATE TABLE mytable(ID INT NOT NULL, Date ???)) ENGINE=INNODB;" what…
My spring boot application is working fine when running it locally. But when I put that on docker it throws error saying that mysql connection cannot be made Error in the console srikulamedura-skm-server-1 | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[spring-orm-6.0.9.jar!/:6.0.9] srikulamedura-skm-server-1 | at…
Sorry in advanced If this question did not include the proper tags. I'm trying to build out a CRUD API using MySQL in NodeJS. I want to pull my DB credentials from the enviromental variables. Right Now I'm trying to…
I have the following table_1 which shows the time each person in Room_A. person start_time end_time John 5 16 Mary 7 10 Peter 8 12 Then I want to have an output table which shows the time and the people…
# index: `review_count`, `store_id`, `status`, `name`, `address` EXPLAIN ANALYZE SELECT store0_.name, store0_.status, store0_.name, store0_.address, category1_.name from store store0_ inner join category category1_ on store0_.category_id=category1_.category_id left outer join store_keyword storekeywo2_ on store0_.store_id=storekeywo2_.store_id left outer join keyword keyword3_ on storekeywo2_.keyword_id=keyword3_.keyword_id where store0_.review_count…
I want to format date-times in a SpringBoot REST API I'm building in the format "dd/MM/yyyy HH:mm:ss.SSS". So I've put it in a global constant: public static final String GLOBAL_DATE_TIME_PATTERN = "dd/MM/yyyy HH:mm:ss.SSS"; and I've annotated my DTO's LocalDateTime field:…