I tried to solve a problem code in Hackerrank. An OCCUPATIONS table that contains the following records: and here are for the sampel output: Ashely(P) Christeen(P) Jane(A) Jenny(D) Julia(A) Ketty(P) Maria(A) Meera(S) Priya(S) Samantha(D) There are a total of 2…
I have a database delta file (.sql) and it contains sql statements such as Insets, Delete, Update. The database is setup with the tables and data, I am simply trying to execute these updates I am trying to find a…
I have millions of rows of data in MySQL DB. Can you suggest me any services or platforms that support JOINS and fast data retrieval. I have looked on elastic search and manticore search, but these don't support JOINS. So,…
I have a table called cars, and I would like to select the cars.variant into variables for three cars, where each metric column totals an independent amount. For example, let’s say @car1 := ‘Ferrari’, @car2 := ‘Audi’, @car3 := ‘BMW’…
I’m trying to get the amount of kWh consumed by my smart plug, my database is MySQL, I’m sending to my zabbix server (which uses MySQLdatabase) the power consumption in watts every minute. ex: SELECT FROM_UNIXTIME(clock) as ts, value FROM…
I have this query that will find a specific borrowDetail when i tried value 2 it does return data from me but when i tried to find the 1 it does not give any data. SELECT bd.BorrowDetails_ID, b.User_ID, b.Accession_Code, bk.Book_Title,…
Suppose I have a table 1 (4 rows and 3 columns) which is already in a database, I want to expand to table 2 using table 1 and variables (A, B, C, D). Table 2 will contain 8 rows and…
Lets say I have 2 tables: User: ID: PK, AI username: varchar pwd: varchar addressID: FK references address.ID Address: ID: PK, AI street varchar, houseNr varchar, postal varchar, How would the history tables look like since we obviously have foreign…
I have a two tables in MySQL database: vehicle vehicle logs When the user inserts a vehicle into the system, the vehicle logs table also generates a new 'vehicle added' row. When something happens to the vehicle, the log table…
I have an enormous orders table that I need to purge having certain city_id's. I created a stored procedure that accepts 1 parameter and deletes 10,000 records at a time and it works well. The city_id's come from a table…