More detailed question. I have a table called CALCS with the structure: code is the record identifier (not unique) value1, value2, value3,value4 are different values to sum price is the cost of work I must return price+value1+value2+value3+value4 for all records.…
Hello, I have an adminController as below. Even though I checked the status box, it comes to the database as zero. I can't figure out why if/else block doesn't work. If I use debug i can see "on" value for…
I have a column in my database table where the default needs to be 'int 0' but also null can be provided due to legacy. I have attached a picture to show what I am trying to do. The problem…
I have a Lambda function that connects to my EC2 MySQL database and can successfully connect, query and use it to retrieve json data. I wanted to improve on this Lambda function by providing parameters to the query such that…
I need to get the total price per month. I have inited_time (ex. 20160530105130) first_payment_price deleted I tried grouping by inited_time SELECT inited_time, DATE_FORMAT(inited_time, '%c') as month, SUM(first_payment_price) as price FROM some_table WHERE inited_time > 0 AND deleted = 0…
I have a myPlaylistSongs table, and there are Playlist_ID and Song_ID columns in it. Each row can have only one value, and the table format is as follows. ===================== Playlist_ID | Song_ID --------------------- 1 | 5 1 | 3 1…
I have a table where it stores the types of discounts that a user can have. Some users will get the standard discount, but some will get a bigger and better discount. For users who have the biggest and best…
Although this situation is easy for ready overrided methods, I couldn't find a way for my own query. This is my repository : public interface CommentRepository extends JpaRepository<User , Long >{ @Modifying @Transactional @Query( value="delete from users where first_name=:name" ,…
MariaDB 10.3.36 i need to calculate the timediff in sec between the date row and create a new column like diff_sec
I got 3 tables | ID | Name | |:---- |:------:| | 1 | Brie | | 2 | Ray | | 3 | James | Table2 | ID | Q_id | Q_no | ans | |:---- |:------:| -----:|----:| |…