I have a table containing full of movie genre, like this: id | genre ---+---------------------------- 1 | Drama, Romance, War 2 | Drama, Musical, Romance 3 | Adventure, Biography, Drama Im looking for a way to get the most common…
My table has the following columns Column Data type (PK) table_id INT AUTO_INCREMENT start_time TIME end_time TIME duration DECIMAL(10,2) When someone adds a row to this table, I want it to calculate the difference in hours between the start and…
(I have no idea how to title this question) I have two tables: leads and calls leads consists of unique lead_id values for each lead and the associated phone_number for that lead. There can be many leads with the same…
. I need to find the order ID and the largest order in terms of dollars using SQL. I attached the OM database. Using SQL I think I would need to use group by or order by but I just…
I have a MySQL table like follows, where each row represents an event for a class. Each class can have from 1 to N events. classId date message 54 2020-08-31 08:24:04 ... 54 2020-08-31 08:32:15 ... 54 2020-08-31 08:32:31 ...…
I want to delete data which are past 2years. filed name is Date and type is varchar(255) delete from <table_name> where <Filed> like '%2022'; running very longtime but no deletion of data
I am trying to add a search form to my application. I thought I had everything right, but Laravel keeps on telling undefined $users in the view. The Form Below <form action="{{URL::to('/students')}}" method="post"> @csrf <div class="my-3"> <div class="input-group"> <input type="search"…
Good afternoon! I have a following program in C++, in VS Code. The program reads all data from a table called student. I compile this program with the command g++ retrieveDataFromTable.cpp -I "C:Program FilesMySQLMySQL Server 8.0include" -L "C:Program FilesMySQLMySQL Server…
Data from table users As you can see there are id and added_by_id columns, I want to fetch all the users added by a specific id but if the id in that result has also added someone then I should…
I have a MySQL 5.7 table that looks like this: id meta 1 null 2 {"grant_ids": [5, 7]} I'd like to query for rows that have the presence of the value of 5 in meta-> grant_ids. I tried select *…