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 | |:---- |:------:| -----:|----:| |…
I have a table name deny_keywords in database with this structure: id word 1 thief 2 crook 3 killer and I have an input that user can send a text and this text Placed in variable name $user_text. Now I…
I have a dataset in a mysql DB, where there is no documentation nor anybody who could tell me why things have been done the way they are or how should I deal with certain things - I think one…
In a large database, I get a timeout as soon as I combine multiple left joins to find objects that have multiple rows with matching conditions. I want to find all objects that have in a different table the property…