I have tables level_one_table, level_two_table, and level_three_table. level_one_table to level_two_table: one to multiple rows level_two_table to level_three_table: one to one row Goal: select them all and level_two_table rows able to use LIMIT and ORDER BY. Return data structure like below:…
My issue is that we use Debezium to monitor the DB events and even when the is a simple update of the data present in the plugin table, the OCS inventory source code performs a delete and an insert operation…
I have a DB with two tables: employees table: fields = {ID, name} turnShift table: fields = {ID, date, ID_employee1, ID_employee2} Here is an example of this DB. Using MYSQL, I'd like to execute a SELECT query able to show…
What I am trying to do is to calculate the sum of the 2 tableSpaces I have in my PostgreSQL DB. SELECT pg_size_pretty (pg_tablespace_size ('pg_default') ); with this query I am able to find the used space but when I…
I have codes see below which is works. $city = City::find(1); $city->location = DB::raw('geomfromtext('point(' . $location . ')')'); $city->save(); Question 1: Is there SQL injection issue in the codes above because I using DB::raw() which sticking the string(variable) in without…
I have a table with jsonb column, turns out storing a lot of json data in this column per row is taking too much space, with around 90M records this table has consumed around 167GB storage. Now I want to…
For the last few days, I have been working to write a MySQL query to extract a result. Basically, I have to join two tables log and conditions table based on any column of the log table from the trigger_param_value…
Problem Statement: We will be getting a request of a number (11 digits) and have to efficiently lookup in the database and return a single row (last updated) based on range in which it fits. Also, I have already used…
The data model is something like this: "_id":... "special_offers": [ 0 => Object, 1 => Object, ...] I just need to get 0 => Object, I mean, the first item of the special_offers array. Here is what I've tried: But…
I want to get the list of users who are new users vs returning user. Report is taken for every week. If user logs in for the first time in a week he is considered as new user,in a week…