I'm trying to validate the users logged in based on month. SQL current df user id date P1302 2023-11-01 P1302 2023-10-01 P1302 2023-09-01 P1302 2023-08-01 P1302 2023-07-01 P1302 2023-06-01 P1301 2023-11-01 P1301 2023-10-01 P1301 2023-08-01 P1301 2023-07-01 P1301 2023-06-01 expected…
Introduction: I want to set a limit for how many technical tests, a user can take. Once that limit is exceeded, I want to delete the remainder, which will represent the earliest submitted technical tests. First in, first out type…
I have table with 5 million rows. Example +----+-----------+---------+------- | product | date | count | +-------------+------------+-----------+ | платье | 04-01-2024 | 186574 | | штаны | 04-01-2024 | 20564 | | кепка | 07-01-2024 | 104443 | | штаны…
Can we create a live connection between PowerBi and MySql so that the dashboard reflects the changes made in the database without having to do a manual refresh from PowerBi desktop everytime? I have tried scheduled refresh but i want…
In my 000webhost account c-panerl is not working. Whenever I try to login with my email and password It's showing this error message. My email and password was correct too. enter image description here I'v tried changing the security settings…
I'm looking to sort multiple tables that are in a database based on the last time the table was updated. The tables all have a column called Update_Time that updates the timestamp when that row is updated in the table.…
I have an application that connects to an API and performs some writes and reads in a database. When creating the integration test suite, I create an empty database and for each test, I create the schema (mirroring the production…
I am working on a system using JPA where Entity 'Events' are associated with Entity 'Groups' and each Group has five boolean columns (Group1, Group2...) indicating their attendance status for an event. Now, I need to enhance the system by…
I have this majors table id name group score 1 Computer Science A 688 2 Electrical Engineering B 647 3 Psychology A 616 (more data on the link below) And this tests table id group score 1 B 690 2…
I'm using Mysql 8.0.33. I created a composite index with the expression column_name is not null and can't get the index to be used. What am I doing wrong? CREATE TABLE appointments ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT…