I have the following tables: CREATE TABLE usuarios ( id INT, nome varchar ); INSERT INTO usuarios VALUES (1, 'Teste'), (2, 'Teste1'), (3, 'Teste2'), (4, 'Teste3'), (5, 'Teste4'), CREATE TABLE FichaColab( id INT, nomcompleto varchar ); INSERT INTO FichaColab VALUES…
I still have a question in my mind. So I've been wondering if it's better to upload a file (like images/docs/pdf, etc.) in MySQL but it said it would be slower...so it better to used a server-side but I don't…
I need to do a SUM of the last value (by date) of each day of the current week. To test I have a table with the values: 5 for 2023-01-12 16:53:01 2 for 2023-01-12 08:49:03 5 for 2023-01-11 08:58:19…
Table information: | player_id | int | | device_id | int | | event_date | date | | games_played | int | +--------------+---------+ (player_id, event_date) is the primary key of this table. This table shows the activity of players of…
row_number query question. To get the data where rn is 1, you can wrap the query below and import it with where rn = 1. Is there a way to get only those whose rn is 1 in the current…
I've stored a X, Y coordinate system in mysql where x-axis values are from A, B....AA, AB... and so forth, just like columns are named in Excel. Y-axis values are from 1 to 100. I can't figure out how to…
Following regex (s*select([^()]*)) giving all subqueries but it ignores when subquery contains any sql functions like max(), count(), ....etc regex works for below SELECT student.name, teacher.name, sub.subject_name FROM student student JOIN teacher teacher on teacher.id=student.teacher_id JOIN (select subject.name subject_name, subject.id…
How to get AVG of a column only if the all the row values for this specific column are not equal -1 ? I have a table with a column named quarter, Its value can be 0-100. But in case…
I'm working on a spring boot project example and I have already created the database but when I configure the database, it doesn't seem to work. It doesn't give me an error though but when I execute the application, nothing…
Trying to write a query from the following table that calculates a count of records for every day date(timestamp) and the prior 4 days. So basically a rolling count of records for every previous 5 days. Every time i do…