Let's say the table looks like this: user id date Amount 123 2022/11/01 5 456 2022/11/02 6 789 2022/11/03 8 123 2022/11/02 9 456 2022/11/04 6 789 2022/11/05 8 I want to calculate the sum of the very last transaction…
Starting the spring boot application with a docker mysql instance ends up in the below exception. I have started the mysql docker instance and was able to view the databases via cli. I am not using docker-compose but docker commands…
I'm relatively new to web development, but I'm working on a React project where I'm trying to interface with an AWS database. To install MySql, I ran npm install mysql, which did end up importing the module, however I now…
Let's say I have a table. create table hour_ranks( id int not null auto_increment, hour_int int not null comment 'hour of that ranks, for example 2022100108 which means October 1st, 8 oclock,2022', audio_id int not null comment 'from audio table',…
I want to show the count in the SQL query, but I have a problem with it. I want to search for count only if there is something specific in the value column. Here is an example of my query:…
I need to add a new row for all post_ids that equal specific condition. So there is a table with post_id, meta_key and meta_value id post_id meta_key meta_value 1 100 page-type city 2 100 banner "banner" 3 101 page-type city 4 102 page-type city…
How can I select data from my SQL table which look like this: | Title | Date | Active | | A | 2022-02-01| 1| | B | 2022-01-01| 1| | C | 2022-04-01| 1| | A | 2021-02-01| 0|…
I have seen a few post's regarding slow queries but none had the answer I'm hoping for. I've been staring at this query for ages and for some reason cant see whats making this so damn slow dates such as…
I have an table like this: id //not index origin 1 germany 1 usa 2 usa 2 I want to get every Entity witch has an origin (!= '') but in a multidimensional Array, sorted by the id, looking like…
I have this 2 queries that I would like that could be retrieve in onw shot. If I run both separately, they dont work. SELECT (SELECT count(id) FROM numeracao WHERE DATA >= '2022-01-01' AND DATA<='2022-12-31' GROUP BY MONTH(DATA)) AS A,…